Unsure what formula to use!

[MrRustyExcel]

Hi all, hoping you can help, have done a quick search of the forum but wasn't able to find a specific answer.

I'm trying to create a monthly scoring spreadsheet based on actions carried out and the dates these occured. I'm not entirely sure I've gone about/set this up in the right way, but so far I was looking at something like this...

The outcome I'm trying to reach is that each of the actions (added, attended, etc) has a score associated with completing that action which appears in row 1 and that from this we can work out a score for a month. E.g. in November we scored 3 points on the above, Burgers Co was added and attended. Is there potentially a more sensible way of doing this without trying to chain multiple if statements together? Could a pivot table perhaps be more effective to sum the scores within a date range?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=sumifs(B1:F1,B3:F3,">="&A8,B3:F3,"<="&A9)

 

[MrRustyExcel]

Ah wow, ok thank you for the quick response! That seems much more straightforward! Would that approach work over multiple lines, say for example if Burgers Co and Chips Co were both added in November?

 

[MrRustyExcel]

I did try and just go straight with changing =sumifs(B1:F1,B3:F3,">="&A8,B3:F3,"<="&A9) to =sumifs(B1:F1,B3:F4,">="&A8,B3:F4,"<="&A9) but that returned a value error

 

[Fluff]

If you want to do multiple rows try

=sumproduct((B3:F4>=A8)*(B3:F4<=A9)*(B1:F1))

 

[MrRustyExcel]

You are a legend, thank you

 

[Fluff]

You're welcome & thanks for the feedback.