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 Joey,
I noticed you protected your sheet and hid the formulas in your file. This isn't particularly helpful for people in the forum.
After unprotecting your sheet I can see that you have used VLOOKUPS on a moving range (as the formula moves down the VLOOKUP range moves down), this could easily result in values not being picked up and if you are using this approach anywhere I'd recommend you should use $ sign to lock that VLOOKUP range reference.
I noticed you protected your sheet and hid the formulas in your file. This isn't particularly helpful for people in the forum.
After unprotecting your sheet I can see that you have used VLOOKUPS on a moving range (as the formula moves down the VLOOKUP range moves down), this could easily result in values not being picked up and if you are using this approach anywhere I'd recommend you should use $ sign to lock that VLOOKUP range reference.
Hi! Wyn,
My apologize, i forgot to remove the lock. Anyway thank you for reminding me.
PW is (1)
Have a nice day Wyn☺