Count occurrences with conditions in several columns

[Dr DR]

I have 2 columns of data: Temperature and State. Temperature has either 90 or
130 F values and State has either "Up" or "Down" values.

I would like to count the number of occurrences of "Up"s with a temperature
of 90F in the same row, for example. So in the following example, it is 2
Up's with 90F.

Temp - State
90 - Up
90 - Up
130 - Up
130 - Down

I know this can be done with a pivot table. This is an extra step that I
would like to eliminate.

Any suggestions?

 

[Bob Greenblatt]

On 6/11/08 5:07 PM, in article
(e-mail address removed), "Dr DR" <Dr

I have 2 columns of data: Temperature and State. Temperature has either 90 or
130 F values and State has either "Up" or "Down" values.

I would like to count the number of occurrences of "Up"s with a temperature
of 90F in the same row, for example. So in the following example, it is 2
Up's with 90F.

Temp - State
90 - Up
90 - Up
130 - Up
130 - Down

I know this can be done with a pivot table. This is an extra step that I
would like to eliminate.

Any suggestions?

Look in help for the COUNTIF function. It will do exactly what you want.

 

[Dr DR]

I am not sure how to utilize the "criteria" in the countif function for what
I am trying to do. Do you have a suggestion?

Thanks.

 

[Bob Greenblatt]

Use the countifs function and 2 sets of criteria:
=COUNTIFS(A2:A5,90,B2:B5,"Up")

 

[Dr DR]

The countif function is not recognized by my version Excel 2003.

I used the sumproduct function to get what I am looking for.

Thanks!

 

[JE McGimpsey]

The countif function is not recognized by my version Excel 2003.

I used the sumproduct function to get what I am looking for.

COUNTIFS() was introduced in XL07/08.

Note that this newsgroup is dedicated to Mac XL (hence the .mac. in the
group name).

 

[Dr DR]

Oh, got it, thanks!

COUNTIFS() was introduced in XL07/08.

Note that this newsgroup is dedicated to Mac XL (hence the .mac. in the
group name).