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"

=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" <moglione1.1vsy6d_1127462703.3796@excelforum-nospam.com> wrote
in message news:moglione1.1vsy6d_1127462703.3796@excelforum-nospam.com...
>
> 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" <moglione1.1vsy6d_1127462703.3796@excelforum-nospam.com> wrote
in message news:moglione1.1vsy6d_1127462703.3796@excelforum-nospam.com...
>
> 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!!!!!!!!!!!

Sounds like you haven't implemented as shown.

Give some sample data and the formula you used.

--
HTH

Bob Phillips

"moglione1" <moglione1.1vt6ic_1127473510.2325@excelforum-nospam.com> wrote
in message news:moglione1.1vt6ic_1127473510.2325@excelforum-nospam.com...
>
> 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