Summing based on 2 criteria

**andrewc** · 11-22-2011, 05:56 AM

Hi,

I would like to sum the values in column C if the values in column E are >=25 AND <50. This is easily accomplished in Excel 2007 using the SUMIFS function but how can one do this in Excel 2003?

Thanks

**teylyn** · 11-22-2011, 06:05 AM

Hello,

use Sumproduct()

=sumproduct(--(E1:E100>=25),--(E1:E100<50),C1:C100)

cheers,

**Richard Buttrey** · 11-22-2011, 06:06 AM

Hi,

A couple of ways.

You could either introduce a helper column and add a formula like:

Please Login or Register  to view this content.

copied down

Then use a standard

Please Login or Register  to view this content.

or alternatively use
SUMPRODUCT((C1:C100)*(E1:E100>=25)*(E1:E100<50))
changing the 100 as appropriate

Regards

**teylyn** · 11-22-2011, 06:08 AM

Or

=SUM(IF((E1:E100>=25)*(E1:E100<50),C1:C100,0))

this is an array formula and needs to be confirmed with CTRL-SHIFT-Enter

Summing based on 2 criteria

LinkBack

Thread Tools

Rate This Thread

Display

Summing based on 2 criteria

Re: Summing based on 2 criteria

Re: Summing based on 2 criteria

Re: Summing based on 2 criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions