Posted to microsoft.public.excel.worksheet.functions

Tim

external usenet poster

Posts: 408

Two conditions in a SUMIF function

I am trying to sum a list of numbers but I have two different critia that I
need sorted by. One is week number and the other is Camp Name.

So for the following

Money Week Camp
200 2 Teen
250 1 Teen
320 2 Rock

I would like to be able to input sum money if colume B=1 and C=Teen and
return 200 instead of 450 or 520.

If anyone knows how do that this a little help would be great

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 with two conditions	Neutron1871	Excel Worksheet Functions	1	May 11th 07 01:45 AM
Sumif with two conditions?	thiensu	Excel Worksheet Functions	1	July 13th 06 06:39 AM
SUMIF 2 conditions are met???	Granger	Excel Worksheet Functions	3	November 17th 05 07:32 PM
SUMIF function with 2 conditions	rlandlin	Excel Worksheet Functions	4	September 28th 05 05:50 PM
How do you do a SUMIF function with 2 different conditions?	MusicTeacher	Excel Worksheet Functions	1	August 6th 05 10:36 PM

All times are GMT +1. The time now is 12:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us