Countif Function in Two Columns
 

I have a little problem I am trying to count the # or occurences in once
column as it relates to a specific object in another. An example is below.

ColumnA ColumnB
LA Cancel
DC Submitted
LA Submitted
CH Reschedule
LP Cancel
LA Submitted
DC Submitted

I want to know in a seperate cell how many times does "Submitted" appear in
ColumnB when "LA" appears in columA (for this example the answer is 2). Any
help would be appreciated. Thanks
--
Bill

Countif Function in Two Columns
 

Try this:

=SUMPRODUCT((A1:A25="LA")*(B1:B25="Submitted"))

OR
You could assign particular cells to contain your items to count, so that
you could change the criteria without having to change the formula itself:

=SUMPRODUCT((A1:A25=C1)*(B1:B25=C2))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bigbilliard" wrote in message
...
I have a little problem I am trying to count the # or occurences in once
column as it relates to a specific object in another. An example is below.

ColumnA ColumnB
LA Cancel
DC Submitted
LA Submitted
CH Reschedule
LP Cancel
LA Submitted
DC Submitted

I want to know in a seperate cell how many times does "Submitted" appear
in
ColumnB when "LA" appears in columA (for this example the answer is 2).
Any
help would be appreciated. Thanks
--
Bill

Countif Function in Two Columns
 

Try this:

=SUMPRODUCT(--(A1:A100="LA"),--(B1:B100="Submitted"))

HTH,
Elkar


"bigbilliard" wrote:

I have a little problem I am trying to count the # or occurences in once
column as it relates to a specific object in another. An example is below.

ColumnA ColumnB
LA Cancel
DC Submitted
LA Submitted
CH Reschedule
LP Cancel
LA Submitted
DC Submitted

I want to know in a seperate cell how many times does "Submitted" appear in
ColumnB when "LA" appears in columA (for this example the answer is 2). Any
help would be appreciated. Thanks
--
Bill