SUMIFS not carrying out calculations

[Adam88]

Hi All,

I've encountered an issue that I can't seem to resolve where my SUMIFS formulas are not carrying out the calculations as requested? This is the code I'm using:

=SUMIFS(Transaction!$F$2:$F$2496,Transaction!$D$2:$D$2496,"Dekko",Transaction!$I$2:$I$2496,"January",Transaction!$J$2:$J$2496,"2018")

The sum range, barring the column header, are all numbers in cells formatted to currency. I can't see any obvious mistakes in the above code but I'm by no means proficient with excel formulas and functions!

Can you offer any advice please?

 

[jkpieterse]

What -precisely- is in columns I and J?

 

[Adam88]

Column I is Months and column J is years (eg 2016, 2017 etc). These are not formatted to anything other than the default (General?).

Thanks

 

[jkpieterse]

But what is IN those cells? if the year column contains numbers your formula is wrong and you should remove the "" around "2018".

 

[Adam88]

In Column I (Months) its text such as "January" for example. In Column J (years) it is numbers, such as 2017.

I've gone through to apply your advice and have now fixed the issue; The formula was referencing the wrong column! I'd deleted an entire column during the set up and had forgot to change the references in the formula... Thank you for your input none the less.

 

[jkpieterse]

I assume you forgot to edit the formula in the web post, as Excel would have adjusted the formula for you when deleting columns.