How to use sumifs to sum values across multiple columns?

[mshanGISD]

Hi,

I have a monster of a spreadsheet and I am trying to use SUMIFS to help give an easy view of some of the data. I wanted to sum charges by month and I got it to work with no issue for my Total Charges column, but now I need to break it down even further by services. In my 'AT&T_Data' sheet, I have multiple columns with dollar amounts that I need to sum based on the month the charge was accrued (column F) and the type of service the charge is for (column G). Is anyone able to help me figure out why I am returning #VALUE with this particular formula?

Please note that I cannot just use a pivot table instead, as it is not the preferred format of the users that I am sharing this data with.

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
With sumifs all the ranges need to be the same size. You probably need to use sum & filter to get what you want.