Multiple Columns in Sum Range using SUMIFS

[kristikls]

I'm trying to get a calculation using SUMIFS that looks at 2 criteria t
determine whether a figure should be included in a sum but I want th
Sum Range to span multiple columns. I can get the formula to work for
single column but not multiples.

I guess I can't upload the file here but the formula currently is:

=SUMIFS('New Sales'!$N$11:$N$9999,'New Sales'!$E$11:$E$9999,$A$5,'Ne
Sales'!$J$11:$J$9999,1)

I tried to do a named range and that didn't work. Basically, I wan
where column N is just totally to instead be about 20 columns

 

[Living the Dream]

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