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