problem with sumifs with multiple criteria

Hi all,

Trying to determine what formula to use to total all the values based on if two criteria are met. I tried using sumifs but it repeatedly gave me the wrong response.

In the "template tab", I want a formula that sums all the values in the 12 month sales tab in column "sales category". The two criteria that it has to meet is that the category on the template must match the category on the 12 month sales tab, likewise with the date.

any help with a formula that achieves this objective would be greatly appreciated.

thank you

Excel Array Problem.xlsx

try this:
=SUMIFS('12 Month Sales'!J:J,'12 Month Sales'!A:A,"="&Template!C$3,'12 Month Sales'!G:G,Template!$B5)

=SUMIFS('12 Month Sales'!H:H,'12 Month Sales'!A:A,"="&Template!C$3,'12 Month Sales'!G:G,Template!$B5)
summing up the units

to make the absolute cell reference i inserted $:
=SUMIFS('12 Month Sales'!$H:$H,'12 Month Sales'!$A:$A,"="&Template!C$3,'12 Month Sales'!$G:$G,Template!$B5)

Hi acerrhod, thanks for the help. When I use that formula I'm only getting a value for one category in each column. All the other categories are blank with "-" as a value. There should be values in each of those categories and I'm unsure as to why it is only returning the value for once category and not each individual one.

Any ideas?

to make the absolute cell reference i inserted $:
=SUMIFS('12 Month Sales'!$H:$H,'12 Month Sales'!$A:$A,"="&Template!C$3,'12 Month Sales'!$G:$G,Template!$B5)

I put that formula in and I am still receiving one value for one category and nothing for the other categories.

I attached the file with the formula in it so you can see what I'm seeing. I have no idea why it's not pulling the values for the other categories and dates.

Thank you for your help and patience.
Excel Array Problem.xlsx