Ok I have a worksheet that I enter all my daily information into for my job.
In one column i enter either J or R to let me know what type of transaction
it is.
in another column i enter a category which can be 1 of 5 words.

What I want is a count of all transactions from category 1 that are of type J
so lets say in column A i have(from row 1 to 5) R J J R J
and from Colmn B i have(from row 1 to 5) Circle Circle Square Square Circle

I then want a count of how many Circles i have of type R.

I tried to use the COUNTIF function like so...
=COUNTIF(A1:A5,"R") & COUNTIF(B1:B5,"Circle")
the answer i got was 23 2 = the number of R's in that column and 3 =
number of "circle" in that column. not exactly what i wanted.

So I ask you, what am I missing? I'm fairly new to this type of excel
formating so I'm probably using the wrong function or using it in the wrong
manner. Thanks for any help

Try this

=SUMPRODUCT((A1:A5="R")*(B1:B5="Circle"))


"barrett" wrote:

Ok I have a worksheet that I enter all my daily information into for my job.
In one column i enter either J or R to let me know what type of transaction
it is.
in another column i enter a category which can be 1 of 5 words.

What I want is a count of all transactions from category 1 that are of type J
so lets say in column A i have(from row 1 to 5) R J J R J
and from Colmn B i have(from row 1 to 5) Circle Circle Square Square Circle

I then want a count of how many Circles i have of type R.

I tried to use the COUNTIF function like so...
=COUNTIF(A1:A5,"R") & COUNTIF(B1:B5,"Circle")
the answer i got was 23 2 = the number of R's in that column and 3 =
number of "circle" in that column. not exactly what i wanted.

So I ask you, what am I missing? I'm fairly new to this type of excel
formating so I'm probably using the wrong function or using it in the wrong
manner. Thanks for any help

Yes I think that's what i was looking for. Thanks much. Seems to work
correctly I'll test it more.

"AKphidelt" wrote:

Try this

=SUMPRODUCT((A1:A5="R")*(B1:B5="Circle"))


"barrett" wrote:

Ok I have a worksheet that I enter all my daily information into for my job.
In one column i enter either J or R to let me know what type of transaction
it is.
in another column i enter a category which can be 1 of 5 words.

What I want is a count of all transactions from category 1 that are of type J
so lets say in column A i have(from row 1 to 5) R J J R J
and from Colmn B i have(from row 1 to 5) Circle Circle Square Square Circle

I then want a count of how many Circles i have of type R.

I tried to use the COUNTIF function like so...
=COUNTIF(A1:A5,"R") & COUNTIF(B1:B5,"Circle")
the answer i got was 23 2 = the number of R's in that column and 3 =
number of "circle" in that column. not exactly what i wanted.

So I ask you, what am I missing? I'm fairly new to this type of excel
formating so I'm probably using the wrong function or using it in the wrong
manner. Thanks for any help