Mar 26 2019 03:24 AM
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.
Mar 26 2019 03:30 AM
@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)+...