Sumifs

[Dhoang25]

Hello,

I have 2 tabs in my spreadsheet: 1) Summary 2) Performance

In my performance tab, I have the daily productions of each negotiator. In the summary tab, I want the MONTHLY production total of "APR" for each nagotiator. I tried using SUMIFS but it's not working! Here is my formula below. Please see attachment! Thanks for your help!

=SUMIFS(Performance!$D$2:$M$7,Performance!$A:$A,$A3,Performance!$C:$C,"APR")

[dcgrove]

All of the ranges used in a sumifs formula must be the same size. You are likely going to have to rearrange your data into an actual table to use a SUMIF. I have uploaded your workbook with a different arrangement for the data to show you how I would arrange it.

[Dhoang25]

Hmm...Unfortunately, sr. management wants to see it in this format! Is there another alternative way of calculating this?

[dcgrove]

Use the sumproduct formula so that you can sum the different sized arrays with multiple criteria.


More reading on SumProduct:


http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[brokenbiscuits]

You could instead include a total column in col N of the Performace tab, and then use the following:

=SUMIFS(Performance!N:N,Performance!$A:$A,$A3,Performance!$C:$C,"APR")

[dcgrove]

I thought about that, but after his last comment, wasn't sure if he was free to change the format of the table.

[Dhoang25]

Awesome! Thanks guys!!!