Counting cells with specific content for a rolling date range

[epyzdrh]

Hi,

I'm trying to put together a formula that will count the total number of "b",, "t" or "v" are in a row based on a rolling 180 days starting from today and 180 days into the future. If the dates are in row A as per the picture I thought I could use a countifs referencing that first and keep that fixed for each row? Any thoughts?

 

[Fluff]

I thought I could use a countifs referencing that first and keep that fixed for each row?

That should work without problems.

 

[epyzdrh]

=COUNTIFS(F2:WQ2,">=TODAY()",F2:WQ2,"<=TODAY()+180") this is my starting point, would the B, t and v just then be additional criteria?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

would the B, t and v just then be additional criteria?

Yes they would, but they need to done as an or like

=SUM(COUNTIFS($F$2:$WQ$2,">="&TODAY(),$F$2:$WQ$2,"<="&TODAY()+180,F3:WQ3,{"b","t","v"}))

This may need array entry depending on your version of Excel.

 

[epyzdrh]

Thankyou that works perfectly. Will do, just reactivated my account today so will update it now.

 

[Fluff]

Thanks for that.