Cross-Column Check and then Countif?

[stevieb123]

Hello, I am trying to figure out if this certain excel function is at all possible.
Say we have column A with values ranging from 1.00 to 999.99 unordered. Then we have column F with text either "In Process" or "Completed". Is there any way to take a range of those values, say 1.00 to 399.99, and then within that range check column F if it contains the text "in process" or "completed".

I have the formula for the range, which is, =COUNTIF(Table1[APPM_ID],">=001") - COUNTIF(Table1[APPM_ID],">199")
and I also have a formula to count the number of In processes in the entire document, =COUNTIF(Table1[Review Status],"*In Process*")

But how do I combine the two, to check the process in a given range, and then count that value?

See image: https://imgur.com/a/v1R95

Thank you, any help would be much appreciated

 

[Joe4]

Welcome to the Board!

I think the COUNTIFS function may do what you want. It is like the COUNTIF function, but can handle multiple conditions.
See: https://www.techonthenet.com/excel/formulas/countifs.php