SUMIFS Function

Hello guys, I need help on using SUMIFS in my excel file.

I used this formula to calculate the "total calls" (RAW DATA'!I:I) based on the "seller name" (RAW DATA'!D:D) and it will display the totals based on the "seller name" (SELLER DRAFT'!D5) with the date range from July 01-31 (RAW DATA'!E:E,">=01/07/2015",'RAW DATA'!E:E,"<=31/7/2015").

The full formula:

=SUMIFS('RAW DATA'!I:I,'RAW DATA'!E:E,">=01/07/2015",'RAW DATA'!E:E,"<=31/7/2015",'RAW DATA'!D:D,'SELLER DRAFT'!D5)

Maybe it is how I arrange the criteria.

Thanks.

Hi,

Your SUMIF formula seems alright to me. Do you not get the desired output when you apply this?

Thank you so much for all your replies but, the formula doesn't have an error the only problem is that the result must be 40 but this formula returns 0.

Thanks.

Can you post a sample file here?

Good day,

Thank you for the response. I have attached the sample file.

Thank you.

Hi,

The dates in column E has formatting issues because of which the SUMIF was not getting calculated. I have added a helper column to sort this out and applied the below formula & it works fine now.

In O5:

Please Login or Register  to view this content.

See the attached file.

Good day,

The formula is now working but the data is not displaying correctly, I have attached another file.

Thank you.

Hi,

You need to modify the formula to pick up the correct month:

Try the following formula in E6:

=SUMIFS('RAW DATA MONTH'!$I:$I,'RAW DATA MONTH'!$D:$D,'SELLER BY MONTH'!$D6,'RAW DATA MONTH'!$E:$E,">="&EOMONTH(E$2,-1)+1,'RAW DATA MONTH'!$E:$E,"<="&EOMONTH(E$2,0))

I have added a new row to separate the months in the attached file, this way you can drag the formula to other cells without modifying it.

Good day,

Thank you so much to everyone who helped solved my SUMIFS formula, it is working fine now.

Thanks

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.