Posted to microsoft.public.excel.worksheet.functions

Living the Dream Living the Dream is offline

external usenet poster

Posts: 151

Multiple Columns in Sum Range using SUMIFS

Try

SUMPRODUCT(('New Sales'!$N$11:$N$9999)*('New
Sales'!$E$11:$E$9999=$A$5)*('New
Sales'!$J$11:$J$9999=1))

HTH
Mick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
SUMIFs across multiple sheets	kwyjibo jones	Excel Worksheet Functions	8	April 4th 23 02:30 PM
SUMIFS, one criteria range, multiple criteria	GavinS	Excel Worksheet Functions	2	September 7th 11 05:40 PM
sumifs multiple columns help	duketter	Excel Worksheet Functions	2	May 8th 10 08:44 AM
Multiple Sumifs	Emeryville John	Excel Worksheet Functions	1	September 19th 08 10:12 PM
SumifS Multiple Sum Ranges	Harlan Grove[_2_]	Excel Worksheet Functions	0	May 23rd 07 08:40 PM

All times are GMT +1. The time now is 05:34 AM.

About Us

"It's about Microsoft Excel"