Counting Formula
 

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!

Counting Formula
 

=SUMPRODUCT(--($A$2:$A$200="Expired"),--($B$2:$B$200="Production")

etc.

--
__________________________________
HTH

Bob

"Matt" wrote in message
...
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!

Counting Formula
 

Matt wrote:
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!


Try a PivotTable.

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