Summing alternate columns, with formulas in the cells

[SloopJohnB]

How can I sum columns if the cells are formulas, such as

D3 =F3+H3+J3+L3+N3+P3
Where the following cells are:
Cell F3 =IF(ISNA(RANK(E3,E$3:E$62,1)),"",RANK(E3,E$3:E$62,1))
Cell H3 =IF(ISNA(RANK(G3,G$3:G$62,1)),"",RANK(G3,G$3:G$62,1))
Cell J3 =IF(ISNA(RANK(I3,I$3:I$62,1)),"",RANK(I3,I$3:I$62,1))
Cell L3 =IF(ISNA(RANK(K3,K$3:K$62,1)),"",RANK(K3,K$3:K$62,1))
Cell N3 =IF(ISNA(RANK(M3,M$3:M$62,1)),"",RANK(M3,M$3:M$62,1))
Cell P3 =IF(ISNA(RANK(O3,O$3:O$62,1)),"",RANK(O3,O$3:O$62,1))

Thanks for your help.

[arlu1201]

Your question is not very clear. Can you try explaining again?

[SloopJohnB]

I would like to sum

D3 =F3+H3+J3+L3+N3+P3

Where the cells F3, H3, J3, N3 & P3 are the results of a formula.

Does this explain it better.

[arlu1201]

Are you getting any error when you attempt to sum them? Even if F3, H3, etc should have formulae in them, you should be able to sum them in D3 the normal way.

[Alf]

Assuming that your problem is that the formulas convert numbers to text you could try multiplying all result by 1 and i.e D4=F3*1, D5=H3*1 and so fort. Then sum D4 to D9 in D3.

Alf

[martindwilson]

rank will be a number!

[bebo021999]

@Sloop
You refer to use SUM or other function rather than "+"?
like this SUM(E3:P3) subtract columns E,G,I,K,M,O ?
If yes,

Please Login or Register  to view this content.