Count Today every 3rd column

[jsimpser]

Hi,
I am working with a spreadsheet where I need to count how many times yesterday's date is used in every 3rd column. There are multiple columns with dates, so I only need it from every 3rd column.the below expression works, but to enter it for the entire spreadsheet would take a long time as it goes until FO.

=COUNTIF(H6:H108,TODAY()-1)+COUNTIF(K6:K108,TODAY()-1)...

Anyone know how to do this in one formula instead of mutliple formulas added together?
Thanks!

 

[jsimpser]

I see what I did. Thank you. Works well!

 

[KRice]

You're welcome, and that's great...glad to hear!