Forum Discussion
Solved
formula that will return the sum of values with a given name in a given month
Trying to find a sumif formula that will return the sum of values with a given name in a given month. I have multiple entries within each month that are labeled to fit into a certain category and a ...
Hi Rebecca
Bit of a long formula (I'd also encourage you to turn your 2 Data sets into Tables (Ctrl T) so that the formula is more meaningful.
=SUMIFS('Data 1'!$H:$H,'Data 1'!$E:$E,$A2,'Data 1'!$B:$B,">="&B$1,'Data 1'!$B:$B,"<="&EOMONTH(B$1,0))
+SUMIFS('Data 2'!$H:$H,'Data 2'!$E:$E,$A2,'Data 2'!$B:$B,">="&B$1,'Data 2'!$B:$B,"<="&EOMONTH(B$1,0))
Hi Rebecca,
If you copy the whole formula (not 2 separate parts) it should work (assuming your columns are set up in the same way)
Also I've attached a version including Tables
I set it up just like yours, so maybe there is just something wrong with my data. I'll try to recreate all the data and keep trying different things.
Thank you for your help.