Forum Discussion
Counting Rows based on certain variable combinations
Hopefully my question is clear, and I hope the attachment shows up. I have a large spreadsheet with about a dozen columns of information. I would like to count how many rows have certain cells tha...
I think this is the solution, using wildcards:
=COUNTIFS(B:B,IF(L3>0,L3,"*"),C:C,IF(M3>0,M3,"*"),D:D,IF(N3>0,N3,"*"),E:E,IF(O3>0,O3,"*"),F:F,IF(P3>0,P3,"*"),G:G,IF(Q3>0,Q3,"*"),H:H,IF(R3>0,R3,"*"),I:I,IF(S3>0,S3,"*"))