Formula not working

N

nir020

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

=SUMIF(B3:B158,"east midlands",$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
 
B

Bob Phillips

SUMIF only handles a single column. Try

=SUMPRODUCT(--(B3:B158="east midlands")*($C3:$J158))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top