Try:

=SUMPRODUCT(($O$3:$AC$3),--(MOD(COLUMN(P5:AD5),2)=0),(P5:AD5))*0.01

Or see my other posting.

"Tanya" wrote:

Thank you for your rseponse,

Unfortunately there are values in other columns on rows 3 and 5 that I need
to ignore

"Ron Rosenfeld" wrote:

On Sun, 1 Jul 2007 04:02:25 -0700, Tanya
wrote:

Hi, I hope someone may be able to help me.

I have the following formula which works fine, however the values in P5, R5,
T5, V5, X5, Z5, AB5 AND AD5 may contain text which is messing up my formula.
My reasoning behind needing to do this is calculating student marks over
several tasks, with different % weights and until the assessment task has
been set I have an IF formula based on the false being "-".

I have tried the =IF(ISNUMBER(P5),(P5*$O$3),0,IF(ISNUMBER(R5),(R5*$ Q$3),0,....
and getting all kinds of error messages, in cluding too many augments.

=((P5*$O$3)+(R5*$Q$3)+(T5*$S$3)+(V5*$U$3)+(X5*$W$ 3)+(Z5*$Y$3)+(AB5*$AA$3)+(AD5*$AC$3))*0.01

I would appreciate any assistance here.

Thanks
Tanya


I note that the data is in every other column, with row 5 offset by 1 column
from row 3.

SUMPRODUCT will ignore text. So if there is no numeric data in the intervening
columns, you could use this formula:

=SUMPRODUCT($O$3:$AC$3,P5:AD5)


--ron