Thread
:
Count function question
View Single Post
#
2
Don Guillett
Posts: n/a
try this idea
=sumproduct((a2:a22="AppDev")*(b2:b22="active"))
and to sum col c that meets that criteria
=sumproduct((a2:a22="AppDev")*(b2:b22="active")*c2 :c22)
--
Don Guillett
SalesAid Software
"John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us wrote in message
...
I am looking to write a formula, but I'm stuck.
I have a three columns: Project Name, division, phase. I want to write a
forumula that counts the number of projects per division per phase. For
instance, I want to know how many projects are in the AppDev division that
are active. Likewise, I want to know how many Telecom projects are
inactive...etc.
I've tried Count and CountIf functions, but I'm not getting the result
that
I want.
How do I go about calculating this?
Thanks
John
Reply With Quote