Home

Excel Countifs

Dina63
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

=COUNTIF(G1:G600,cond1)+COUNTIF(G1:G600,cond2)+...

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies