Sumif

[jsramsey]

Is there a way to "sumif" Rows example =SUMIF(C7:T7,"w",C7:T7) and not in columns.....


I keep getting a 0 as the Value


Thanks

[olasa]

You can not sum "w"´s... ;-)
But if you mean, -Can I sum row values when the criteria is in a column?
Yes. Example: =SUMPRODUCT((C7:T7="w")*TRANSPOSE(A1:A18))
(but not with sumif(.)...and make sure that the number of rows=the number of columns)

Hope this helped
Ola Sandström