# COUNTIF formula with multiple Arguments

• I'm trying to calculate the number of itmes in one Cell that also has a specific values in another Cell.

Example: I have a column for Job Type, F. Name, L. Name, and Age. I want to create a formula that displays the number of times a particular Job Type and F. Name displays in the columns.

I've attached a sample spreadsheet. In it I've listed in Cells F3 - F6 what I'm trying to accomplish and in Cels G3 - G6 were my attemps (most failed), I was able to use the CountIF formula to calculate the first one (F3/G3) but, the others are not as easy because they require two values be specific.

## Files

• Re: COUNTIF formula with multiple Arguments

Try this

## Files

HTH

Bob

• Re: COUNTIF formula with multiple Arguments

Thanks guys, that worked, in my actual spreadsheet I'm working in two worksheets and using the formula you two suggested I was always getting 0, then I noticed I had quotes around my cell value, once they were removed it calculated properly.

thanks again.

Just curious: couldn't this also be done using the Count formula? Just an FYI for me, thanks.

• Re: COUNTIF formula with multiple Arguments

Yeah, you could with array formulae such as

=COUNT(IF((\$A\$3:\$A\$16="Orange Picker")*(\$D\$3:\$D\$16<24),D3:D16))

HTH

Bob

• Re: COUNTIF formula with multiple Arguments

Hi,

Just wanted to say, I needed to learn how to use SUMPRODUCT and this thread has been incredibly useful.
Thanks so much all!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!