Counting Formula

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have two columns that I need to count up the values of. One column is a
"Status" column that either have the values or "Live" or "Expired". The
second column, which is a "Type" column, have the values of "Production",
"Resources", or "Communication". I'm trying to figure out how to count up all
"Expired" values that is located under "Production"; All "Expired" values for
"Resources" and so forth. Can anyone help? Thanks!
 
Matt said:
I have two columns that I need to count up the values of. One column is a
"Status" column that either have the values or "Live" or "Expired". The
second column, which is a "Type" column, have the values of "Production",
"Resources", or "Communication". I'm trying to figure out how to count up all
"Expired" values that is located under "Production"; All "Expired" values for
"Resources" and so forth. Can anyone help? Thanks!
Click to expand...


Try a PivotTable.

Put "Type" in the Row Fields and "Status" in both the Column Fields and Data Items.
 

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

Excel Formula - Count Dates from another Sheet 8
If formula current/expired/blank 3
How to store the calculated value into the original cell? 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Count the columns from one sheet and paste it in another sheet 0
use month in cell date to sum all relevant cells 2
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Counting 3

Back
Top