creating a formula to show totals by month for volunteer org

[Bitie_tony]

Hi

Im trying to create a tracking sheet for our volunteer org which feeds homeless people.

We input how many people we feed each day (B10 onwards) I would like to automatically add up feeds for the month starting from G4.

Looked online and have been battling with creating a SUMIFS formula for it but it is just not working, any help would be HUGELY appreciated

=SUMIFS($B$10:$B$100,$A$10:$A$100,”>=”&$F4,$A$10:$A$100,”<=”&EOMONTH($F4,0))

 

[Fluff]

Hi & welcome to MrExcel.
In what way isn't it working?
Also are you using those slopping quotes in Xl? If so they should be these type of quotes "

 

[Bitie_tony]

Hi & welcome to MrExcel.
In what way isn't it working?
Also are you using those slopping quotes in Xl? If so they should be these type of quotes "

Hay, thank you SO much for getting back to me so quickly. It was the wrong quote marks!!

What a simple fix that I would not have spotted at all.

Have a great day.

Tony

 

[Fluff]

You're welcome & thanks for the feedback.