How do I get a cell to count values from a list dependent on anoth

G

Guest

My first tab is a summary and looks something like this
A1 B1 C1
D1
Status Total D
F
New 5 2
3
Analysis 2 0
2
Analysis Completed 3 3
0

So, the information in the B column is being pulled from
=COUNTIF(STATUS;Analisys!BA1)

The information in the columns C and D is dependent on the list STATUS but
is being inputted manually at the moment

The STATUS list has 5 returns of new. Contained within this tab where the
list STATUS is found the column adjecent to this has either D or F in the
field.

eg.

new D
new F
new D
new F
new F

I am after a formula that will update this on the summary page.

Thanks to anyone who can help.
 
R

Roger Govier

Hi John

In cell C2
=SUMPRODUCT((Status!$A$2:$A$100=A2)*(Status!$B$2:$B$100=C$1))
Copy across to D2
Copy C2:D2 to C3:C4

Cell B2=C2+D2
 

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

How do I COUNTIF from previously counted data? 1
Use cell contents to refer to a sheetname in a formula 6
How do I move entire row from one excel sheet to another 3
How to find best and worst grade? 5
Creating a list from an existing list. 1
Creating a dynamic list 3
Excel How to count the number of times a given condition was meet within a cell in Excel? 1
How do I set up a formula to give me an average based on IF? 1

Top