Please help if you can...
I setup a spreadsheet for reports last year that contains quite a few SUMIFS calculations.
I have several tabs on the spreadsheet that each have these calculations and the majority all work fine.
However, in every tab I have one of these SUMIFS calculations in cell L27. This calculation is now returning no results at all.
The formula I'm using is =SUMIFS(G:G,D:D,"Mural")
Any thoughts on how to fix will be greatly appreciated.
I setup a spreadsheet for reports last year that contains quite a few SUMIFS calculations.
I have several tabs on the spreadsheet that each have these calculations and the majority all work fine.
However, in every tab I have one of these SUMIFS calculations in cell L27. This calculation is now returning no results at all.
The formula I'm using is =SUMIFS(G:G,D:D,"Mural")
Any thoughts on how to fix will be greatly appreciated.