Total Contacts Within Date Range

[cpalmer72]

I am trying to come up with a formula that will look at the table on the left and return the number of contacts each salesperson made each week on the table on the right. For instance, TWL made 43 contacts in the week starting 2/7/22 so that should show up in cell N7. I'm sure it's a fairly simple formula but for some reason my brain isn't working. Help, please!

[Fluff13]

How about in H7 filled down & across

Please Login or Register  to view this content.

[cpalmer72]

Thanks! That worked perfectly!

[Fluff13]

You're welcome & thanks for the feedback.