Mike@Q

Posts: n/a

SUMIF with more than 1 criteria

Hi

I am trying to sum cells that fulfil either criteria A or criteria B. I have
tried =SUMIF(P:P,A1orB1,G:G). I can not simply add two SUMIF's together as I
need to reduce the length of the overall formula.

Thanks for your 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 2 criteria	Jamie	Excel Worksheet Functions	2	November 11th 04 04:48 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
sumif 2 criteria	Doug	Excel Worksheet Functions	1	October 27th 04 05:06 PM

All times are GMT +1. The time now is 09:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us