Counting the number of occurrences that meet my criteria

BFuller

Hello,

I need to count the number of approvals received on the created date, on the day after the created date and on anything after that. Here's my formula that's not working:

=COUNTIFS({VP of Sales Status Approval}, "approved", {Created Date}, ={VP of Sales Status Date})

Any help will be much appreciated. Thanks!

Mike TV

@BFuller

Does it work if you put an = in front of "approved"?

BFuller

Hi @Mike TV . Thanks for the response. It works with out an = in front of "approved". When I do the formula just: =COUNTIFS({VP of Sales Status Approval}, "approved", I get all the responses. What I need to do is count how many of those approvals happen same day, the following day and any day after that. I hope that makes sense. :)

Mike TV

@BFuller

Then I believe you can thread in an OR function with the different criteria you want counted. Probably also use @cell within the OR statement for where it should look at.