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!
Attached is a drop down list of your excel copy. First tab is where all the entries that you inserted from Second Tab (Data 1)
There is some changes that i made but i don't know if this one will help.
Have nice day....
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☺