CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
DantianHealth
DantianHealth

Reputation: 1

Google Sheets Countif with multiple criteria

In a Google Sheet am trying to count the occurrences of a value ("R") in a row (11) where the same column in a different row (4) has the value ("Future") ie in how many columns do I have "R" and "Future".
My current formula is =countifs(M11:BM11,"R",M$4:BM$4,"Future")

Upvotes: 0

Views: 404

Answers (1)

player0
player0

Reputation: 1

try:

=COUNTA(IFNA(FILTER(M11:BM11, M11:BM11="R", M4:BM4="Future")))

Upvotes: 0

Related Questions