Trying to count occurences if 2 conditions are met

=SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))

Mangesh



"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),--(C1:C4>=10))

Mangesh



"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#sS4bD$aFHA.740@tk2msftngp13.phx.gbl...
> =SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))
>
> Mangesh
>
>
>
> "NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
> news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> > Trying to count number of occurences when cost centre is matched and
> variable
> > is greater than a certain amount for an entire list
>
>

One way via SUMPRODUCT, something like:

=SUMPRODUCT(($A$2:$A$10=1111)*($B$2:$B$10>100))

where 1111 is the specific cost centre (in col A) and the certain amt is 100
(in col B)

Adapt to the ranges to suit, but note that you can't use entire col refs in
SUMPRODUCT
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))

Mangesh



"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),--(C1:C4>=10))

Mangesh



"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#sS4bD$aFHA.740@tk2msftngp13.phx.gbl...
> =SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))
>
> Mangesh
>
>
>
> "NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
> news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> > Trying to count number of occurences when cost centre is matched and
> variable
> > is greater than a certain amount for an entire list
>
>

One way via SUMPRODUCT, something like:

=SUMPRODUCT(($A$2:$A$10=1111)*($B$2:$B$10>100))

where 1111 is the specific cost centre (in col A) and the certain amt is 100
(in col B)

Adapt to the ranges to suit, but note that you can't use entire col refs in
SUMPRODUCT
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))

Mangesh



"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),--(C1:C4>=10))

Mangesh



"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#sS4bD$aFHA.740@tk2msftngp13.phx.gbl...
> =SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))
>
> Mangesh
>
>
>
> "NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
> news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> > Trying to count number of occurences when cost centre is matched and
> variable
> > is greater than a certain amount for an entire list
>
>

One way via SUMPRODUCT, something like:

=SUMPRODUCT(($A$2:$A$10=1111)*($B$2:$B$10>100))

where 1111 is the specific cost centre (in col A) and the certain amt is 100
(in col B)

Adapt to the ranges to suit, but note that you can't use entire col refs in
SUMPRODUCT
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

Trying to count number of occurences when cost centre is matched and variable
is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))

Mangesh



"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list

=SUMPRODUCT(--(B1:B4="match"),--(C1:C4>=10))

Mangesh



"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#sS4bD$aFHA.740@tk2msftngp13.phx.gbl...
> =SUMPRODUCT(--(B1:B4="match"),(C1:C4>=10))
>
> Mangesh
>
>
>
> "NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
> news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> > Trying to count number of occurences when cost centre is matched and
> variable
> > is greater than a certain amount for an entire list
>
>

One way via SUMPRODUCT, something like:

=SUMPRODUCT(($A$2:$A$10=1111)*($B$2:$B$10>100))

where 1111 is the specific cost centre (in col A) and the certain amt is 100
(in col B)

Adapt to the ranges to suit, but note that you can't use entire col refs in
SUMPRODUCT
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"NLithgow" <NLithgow@discussions.microsoft.com> wrote in message
news:9211E230-7346-4047-B55F-26750704CE05@microsoft.com...
> Trying to count number of occurences when cost centre is matched and
variable
> is greater than a certain amount for an entire list