Prev: F4 no longer automatically creates absolute reference
Next: barecode command
From: Liz on 4 Jun 2010 15:48
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?

--
Thanks - liz
From: Luke M on 4 Jun 2010 16:09
=SUMPRODUCT(--(C3:C5="YES"),--(B3:B5="Bill"))

--
Best Regards,

Luke M
"Liz" <Liz(a)discussions.microsoft.com> wrote in message
news:A60777DF-823F-4950-91B7-4BB1F7E5392B(a)microsoft.com...
> Trying to count the times "YES" occurs in column C3:C5 for each time
> "Bill"
> indicated in column B3:B5?
>
> --
> Thanks - liz


From: Don Guillett on 4 Jun 2010 16:11
=sumproduct((b3:b5="bill")*(c3:c5="yes"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Liz" <Liz(a)discussions.microsoft.com> wrote in message
news:A60777DF-823F-4950-91B7-4BB1F7E5392B(a)microsoft.com...
> Trying to count the times "YES" occurs in column C3:C5 for each time
> "Bill"
> indicated in column B3:B5?
>
> --
> Thanks - liz

From: Steve on 4 Jun 2010 16:18
Try
=COUNTIFS(C3:C5,"YES",B3:B5,"Bill")

Regards
Steve

"Liz" wrote:

> Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
> indicated in column B3:B5?
>
> --
> Thanks - liz
From: Don Guillett on 4 Jun 2010 18:41
xl2007

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Steve" <Steve(a)discussions.microsoft.com> wrote in message
news:6B06AFF9-1F0D-4435-B07B-1090C487EE54(a)microsoft.com...
> Try
> =COUNTIFS(C3:C5,"YES",B3:B5,"Bill")
>
> Regards
> Steve
>
> "Liz" wrote:
>
>> Trying to count the times "YES" occurs in column C3:C5 for each time
>> "Bill"
>> indicated in column B3:B5?
>>
>> --
>> Thanks - liz

 | 
Pages: 1
Prev: F4 no longer automatically creates absolute reference
Next: barecode command