Convert SUMIFS formula for 2003

**SAsplin** · 12-30-2009, 06:18 AM

Could anyone help me convert the following formula so that it would work in Excel 2003:

=SUMIFS($BB$4:$BB$500,$E$4:$E$500,"Abbeywood First",$L$4:$L$500,"Autumn")

I could play around with it for hours and get nowhere, so I'll just turn to the experts.

Many thanks,

Steve

**royUK** · 12-30-2009, 06:20 AM

You mght be able o use SUMPRODUCT instead

**teylyn** · 12-30-2009, 06:47 AM

maybe

=sumproduct(--E$4:$E$500="Abbeywood First"),--($L$4:$L$500="Autumn"),$BB$4:$BB$500)

**SAsplin** · 12-30-2009, 06:55 AM

Teylyn -

Thanks for that, but your solution comes up with the standard "the formula you typed contains an error" message.

**teylyn** · 12-30-2009, 07:23 AM

sorry, I missed a bracket (xcuse, midight in NZ, concentration waning). Try this

=sumproduct(--(E$4:$E$500="Abbeywood First"),--($L$4:$L$500="Autumn"),$BB$4:$BB$500)