Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count function question
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 |
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Sum and Count Function | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |