Return a number count based on criteria within two separate columns

MrDramaFree

I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column.

For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!

Mark Cronk

Hi @Shane Sorensen ,

Try:

=COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")

Standard COUNTIFS syntax should work for this.

Good luck.

Mark

Mark Cronk

Hi @Shane Sorensen ,

Try:

=COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")

Standard COUNTIFS syntax should work for this.

Good luck.

Mark

Mark Cronk

Hi Shane, Glad it worked. Thanks for using the Community.

Be Well,

Mark