Count function question

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
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)
 

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

SUM Function Question 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count values in array of data where no blanks in one column 4
Counting values in an array where value in one column is not null 5
Function with unknown quantities? 1
Countif function question 1
COUNT function 1
Sumproduct question 5

Back
Top