kia kisi ko ms ofice 2007 ma "sum" ka formula ata hay jo ek line skip kar k baki line ko add kar k un ka sum nekale ...? for example 1,2,3,4,5,6..line hay mane 2,3,6 ko add kar k sum nekalna hay ..kia ya mumkin hay ....?plz help me
kia kisi ko ms ofice 2007 ma "sum" ka formula ata hay jo ek line skip kar k baki line ko add kar k un ka sum nekale ...? for example 1,2,3,4,5,6..line hay mane 2,3,6 ko add kar k sum nekalna hay ..kia ya mumkin hay ....?plz help me
sory nai samajh aya
yar mera matlab hay k mera pas file hay us ma 170 rows hay jis ko mane add karna hay colume D ma ...ma ya chahta hu k ma in sab k sum lu...like this ..=sum(D1170)...is se ya sab row ko add kar leta hay colume D ma ..per ma chahta hu k wo ek row chor k add kare ...mean ...2,4,6,7,8,10,12,14,16.....etc row add kare ....or 1,3,5,7,9,11,13,,,,..... ya wali add na kare ...tp us k liye koi fomula hay kia ??????
aap aise likhain formula bar main
=sum(A2+A4+A6)
Last edited by Kashif Mehmood1; 18th February 2010 at 10:28 AM.
Dear Ye Dekhe agar aap ko line skip karke sum kana he to ye formula acha b or fast b lagta he =sum karne ki zrurt b nai padegi only + press karo phir range pe arrow k madad se jao phir + press karo phir 2nd range pr jao ese e age b karna he
ye Dekhe
try any where with the following formula .
I assume D1170 houses your data.
agar answer wrong mele tu jahan se aap ka data shoro hota ha us cell ka address bata dain. Ya formula m khod adjust kar lain.Code:=SUMPRODUCT(--(MOD(ROW($D$1:$D$170),2)=0),$D$1:$D$170)
hope this will help
regards
Bookmarks