Excel Countifs

Occasional Visitor

In excel I would like to count the number of measurements in column G if the condition in column C is fulfilled. Problem is that in column C I have three different conditions which should be considered; such as. count G1:G600 if C1:C600=cond1 or cond2 or cond3

I hope I was clear enough. Thanks for your help.

1 Reply

@Dina63 , depends on which conditions. If they are constants that could be

=SUM(COUNTIF(G1:G600,{cond1, cond2, cond3}))

or, and if not




Related Conversations
COUNTIFS Question - multiple items in cell
NeilKloster in Excel on
0 Replies
Tie Cells Together
JHaller1288 in Excel on
0 Replies
WhitneyS in Excel on
2 Replies
Excel help
Leesme77 in Excel on
3 Replies
Need help how to do this
Johns_Corner in Excel on
2 Replies