Count if 2 criteria are met

C

clare_s

Hi- need to get a formula which will count the number of times 2 seperate
criteria are met- firstly that in column G the entry is Alicia, and secondly
that in column I there is an entry- have tried to piece this together myself
but as only an occassional user i'm struggling!! Thanks C
 
D

Don Guillett

Also takes into account if someone touched the space bar in i2:i22

=SUMPRODUCT((G2:G22="alicia")*(LEN(TRIM(I2:I22))>0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum total using Sumproduct if two criteria met 5
Count values in one column only if criteria is met in the next column. 0
How do I count the number of entries of specifc criteria is met 2
Returning 1 of 4 values if conditions are met 4
SUMIF criteria in different column is met? 3
Sum data if 3 criteria are met 4
if formula - multi criteria 6
Multiple Criteria Date Count formula 1

Top