ISBLANK

[Aaron Neunz]

I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz

 

[Hayeso]

In Cell B6 Type

=IF(ISODD(ROW(A6)),IF(ISBLANK(A6),"","Whatever"))
And copy it down through B6:B17

 

[Aaron Neunz]

I am totaling in cell A18 and need to have the formula in this cell only

 

[Frank Kabel]

Hi
do you mean
=SUMPRODUCT(--(MOD(ROW(A6:A17),2)=1),A6:A17)