software

I am using the following formula in an excel spreadsheet:-

=SUMIF(B3:B158,quot;east midlandsquot;,$C3:$J158)

However it only gives me a total for column C and not for the entire range
C3:J158

Can you help

Thanks

Nick
SUMIF only handles a single column. Try

=SUMPRODUCT(--(B3:B158=quot;east midlandsquot;)*($C3:$J158))--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;nir020quot; gt; wrote in message
...
gt; I am using the following formula in an excel spreadsheet:-
gt;
gt; =SUMIF(B3:B158,quot;east midlandsquot;,$C3:$J158)
gt;
gt; However it only gives me a total for column C and not for the entire range
gt; C3:J158
gt;
gt; Can you help
gt;
gt; Thanks
gt;
gt; Nick
gt;
gt;