Trying to count occurences if 2 conditions are met

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count if two arguments are true 2
Returning 1 of 4 values if conditions are met 4
Count if 2 criteria are met 1
Cell value when conditions are met 8
Two Condition - search 2
Count function 7
Conditional Counting 7
Returning a value if multiple conditions are met 2

Back
Top