Trying to count occurences if 2 conditions are met
 

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$10100))

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 <atyahoo<dotcom
----
"NLithgow" wrote in message
...
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" wrote in message
...
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" wrote in message
...
=SUMPRODUCT(--(B1:B4="match"),(C1:C4=10))

Mangesh



"NLithgow" wrote in message
...
Trying to count number of occurences when cost centre is matched and
variable
is greater than a certain amount for an entire list