sum formula help
My formula is based on current row number. If row id odd, add the number,
else skip it.
Do you get a #VALUE result?
--
AP
"Aarif" a écrit dans le message de
...
Hi Ardus,
Thanks for giving attention to my problem but when i am using this formula
getting an value error and i am not so familier with excel formulas so
dont
can understand how this formula actually works, this formula looks so
complecated to me,will you help me again to resolve the problem,
thanks again for replying,
Aarif
"Ardus Petus" wrote:
=SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
HTH
--
AP
"Aarif" a écrit dans le message de
...
Hi,
a1,a3,a5.......... =a1+a3+a5.............
can i use a formula that calculate every next row.
Thanks in advance,
Aarif
|