Formula for sum of alternate cells
Clever. How do you find these Lori?
--
Regards,
Peo Sjoblom
"Lori" wrote in message
...
You could also try these two:
=SUM(NPV({0,-2},D23:K23))/2
=SUM(NPV({0,-2},,D23:K23))/2
"John Blackwell" wrote:
Folks,
I'm trying to find a formula for summing the contents of alternate cells
in
a row?
I have a large workbook and want to calculate the contents of row 23 -
i.e.
E23, G23, I23, K23, M23 etc etc, up to KK23. Is there a simple formula
for
this?
John Blackwell
|