Re: Count occurrances with conditions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I didn't sign on to the forum as a guest, I didn't come to the forum at all.
Your forum questions are automatically forwarded to the Microsoft Public
newsgroups which is where I see them.

Anyway, try this alternative

=SUMPRODUCT(--(C17:C37="B"),--(Q17:Q37=1),--(R17:R37<>1))

for bulk items

--
HTH

Bob Phillips

"WMO" <WMO.1th8ad_1123556707.0352@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:WMO.1th8ad_1123556707.0352@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Trying to reach Bob Phillips who logged on as a guest. I appreciate
> your response but it did not resolve my issue. I have now attached a
> portion of the spread*** with more detail.
>
> If you (or anyone else) can make an additional response, I would
> greatly appreciate it. Thanks
>
>
> +-------------------------------------------------------------------+
> |Filename: excel forum.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3678 |
> +-------------------------------------------------------------------+
>
> --
> WMO
> ------------------------------------------------------------------------
> WMO's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26065
> View this thread: http://www.excelforum.com/showthread.php?threadid=394033
>


.

Quantcast