Countif function

staffer · Mar 14th, 2002, 05:07 PM

I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.

Aladin Akyurek · Mar 14th, 2002, 05:11 PM

Quote:

On 2002-03-14 16:07, staffer wrote:
I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.

Care to post 5 rows of data along with the exact ranges where your data are?

Dave Patton · Mar 14th, 2002, 05:21 PM

consider

=SUMPRODUCT((C49:C52="Male")*(E49:E52="Passed"))

-revise the 2 ranges to reflect your data
- assumes word "Male" is in Column C
- assumes word "Passed" is in ColumnE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 05:07 PM	#1
staffer New Member Join Date: Mar 2002 Posts: 1	I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.

Mar 14th, 2002, 05:21 PM	#3
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	consider =SUMPRODUCT((C49:C52="Male")*(E49:E52="Passed")) -revise the 2 ranges to reflect your data - assumes word "Male" is in Column C - assumes word "Passed" is in ColumnE