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!

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

etc.

--
__________________________________
HTH

Bob

"Matt" <(E-Mail Removed)> wrote in message
news:4A02A388-A303-4844-B15D-(E-Mail Removed)...
>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 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.