COUNTTFS depending on criteria

Herllo all,

I need a formula please in coulmn E and F on my spreadsheet.

I want in column E, to count from the number of times D2 Frsh Mt AV Lmb- In Mrnd appears in column A with the text = "Not in MWP" (column B), in this example, the answer is '1' so cell F2 should say 1. If the text is not equal to "Not in MWP" (i.e the text is something else) the number is 0 which should be in E2

this needs to go on down the cells in cell E3 and F3 onwards

please can someone help. thanks!

Try:

Formula:

=COUNTIFS($A$2:$A$7,D2,$B$2:$B$7,"<>Not in MWP")

Formula:

=COUNTIFS($A$2:$A$7,D2,$B$2:$B$7,"Not in MWP")

Thank you!

"e2"

Formula:

=countifs($a$2:$a$7,$d2,$b$2:$b$7,$b$2)

"f2"

Formula:

=countifs($a$2:$a$7,$d2,$b$2:$b$7,"<>$b$2")

You're welcome. Thanks for the rep.

@avk: the second formula won’t work. It needs to be:

Formula:

vcountifs($a$2:$a$7,$d2,$b$2:$b$7,"<>"&$b$2)

Both formulae depend on the contents of B2 which I guess could change.