Counif

M

moglione1

Does anybody know if I can count the number of "STOPS" in one column fr
a particular day of the week in another column.

E.g. I want to count how many "STOPS" occur on a "MONDAY"
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A20="Monday"),--(B2:B20="STOPS"))

if the days are textual, i.e. not real dates. If they are real dates use

=SUMPRODUCT(--(Weekday(A2:A20)=2),--(B2:B20="STOPS"))
 
K

KL

assuming "STOPS" are in column [A] and days are in column in text
format:

=SUMPRODUCT(--(A1:A100="STOP"),--(B1:B100="MONDAY"))

Regards,
KL
 
B

Bob Phillips

Sounds like you haven't implemented as shown.

Give some sample data and the formula you used.
 
D

Dave Peterson

Do you have #num in your data?

Sometimes, it's good to show the formula you actually tried, too.
 
Top