Counif
 

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"


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

=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"))

--
HTH

Bob Phillips

"moglione1" wrote
in message ...

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"


--
moglione1
------------------------------------------------------------------------
moglione1's Profile:
http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

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

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

Regards,
KL


"moglione1" wrote
in message ...

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"


--
moglione1
------------------------------------------------------------------------
moglione1's Profile:
http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

This only produces a #num error.

AAAAAHHHHHHH!!!!!!!!!!!


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

Sounds like you haven't implemented as shown.

Give some sample data and the formula you used.

--
HTH

Bob Phillips

"moglione1" wrote
in message ...

This only produces a #num error.

AAAAAHHHHHHH!!!!!!!!!!!


--
moglione1
------------------------------------------------------------------------
moglione1's Profile:
http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

Do you have #num in your data?

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

moglione1 wrote:

This only produces a #num error.

AAAAAHHHHHHH!!!!!!!!!!!

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141

--

Dave Peterson