Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Count occurences between dates | Excel Worksheet Functions |