Trying to count occurences if 2 conditions are met

N

NLithgow

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

Max

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
 
Top