Countif Function in Two Columns

[Guest]

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

 

[RagDyer]

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))

 

[Guest]

Try this:

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

HTH,
Elkar