Rachelle

Posts: n/a

How do I ask for multiple criteria when creating a "sumif" formul.

I need to create a "sumif" formula in excel that allows me to dictate
MULTIPLE criteria...for example, in range a1:c10, I want to sum cell c3 only
if a1="value" and b1="value", and so on down the line...ideally, I would
creat a formula that looks like this:

=sumif(a1:c10,a1:a10="value1"AND b1:b10="value2",c1:c10)

I've tried layer "if" and "and" formulas in the sumif formula; nothing seems
to work.

HELP!

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 Criteria	Brent Martin	Excel Discussion (Misc queries)	6	January 7th 05 05:17 AM
SUMIF with only one criteria cell within range	Stan	Excel Discussion (Misc queries)	5	December 16th 04 10:12 PM
SUMIF with more than 1 criteria	Mike@Q	Excel Worksheet Functions	4	November 26th 04 12:17 AM
SUMIF multiple criteria	LOU	Excel Worksheet Functions	1	November 10th 04 07:12 PM
Can I use a cell reference in the criteria for the sumif function.	Number Cruncher	Excel Worksheet Functions	2	November 4th 04 07:52 PM

All times are GMT +1. The time now is 01:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us