excel formula problem

[nissa]

hope sab member kheriyat se hon geye
mujhe plz koi member bata dein k hum excel k formula main kisi dusri sheet ko kese use kar sakte hain plzz screenshot k sath bataye ga plzzzzzzzzzzzzzz

[nissa]

plzzzzz koi tu bata dein plzzzzzzzzzzzzzzz

[creative_eyes]

Asalamu alaikum ye formula check karen:

FOR EXAMPLE: TOTAL WALI SHEET ME B2 WALE COLUM ME YE FORMULA
=JAN!B2+FEB!B2+MAR!B2 THEN PRESS ENTER AUR JAB TOTAL DISPLAY HOJAE TO OSI COLUM ME PHIR YE WALA FORMULA =SUM(JAN:MAR!B2) THEN PRESS ENTER....... AAP APNE COLUM KE HISAB SE FORMULA SET KARLO MY NE (YAHAN PER TEEN DIFFRENT SHEET KA TOTAL SHEET NO 4 ME SHOW KIA HI) B2 KE EXAMPLE DIA .... AGAR KUCH PROBLEM HO TO PHIR BATAEN...SHUKRIYA

[nissa]

asalamu alaikum ye formula check karen:

For example: Total wali sheet me b2 wale colum me ye formula
=jan!b2+feb!b2+mar!b2 then press enter aur jab total display hojae to osi colum me phir ye wala formula =sum(jan:mar!b2) then press enter....... Aap apne colum ke hisab se formula set karlo my ne (yahan per teen diffrent sheet ka total sheet no 4 me show kia hi) b2 ke example dia .... Agar kuch problem ho to phir bataen...shukriya

ok thankz

[nissa]

plz close kar dein problem solve

[Sahil_Jaan]

plz close kar dein problem solve