Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Sumif with Multiple Criteria

I am trying to use a sumif with multiple criteria so that it will sum with a
range of data included in the criteria. The criteria will be 50+ cells in a
row.

=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I'm not sure how to get this to work or if I need to use a sumproduct
formula instead?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF multiple criteria	Sarah (OGI)	Excel Worksheet Functions	5	September 26th 07 02:54 PM
SUMIF with multiple criteria	ricky[_2_]	Excel Discussion (Misc queries)	4	July 7th 07 08:06 PM
SUMIF with multiple criteria	Plum	Excel Discussion (Misc queries)	4	April 21st 07 06:31 PM
SumIf with Multiple Criteria	DEE	Excel Worksheet Functions	4	November 21st 06 10:04 PM
SUMIF with multiple criteria	penri0_0	Excel Discussion (Misc queries)	5	May 18th 06 04:55 PM

All times are GMT +1. The time now is 03:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us