Thread
:
Trying to count occurences if 2 conditions are met
View Single Post
#
3
Mangesh Yadav
Posts: n/a
=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 With Quote