SUMPRODUCT is probably the function you would want in this case.

=SUMPRODUCT(--(D1:D10="ASA-2"),--(G1:G10="2"))

Where I foresee that you may run into a problem is with Column G. In your
example you're looking for the text value 2. Is the data in Column G in fact
stored as text? Or is it numbers?

2 and "2" are not the same thing. Remove the quotes from the "2" if your
data is stored as numbers.

HTH,
Elkar


"Gayla" wrote:

Okay I give up! I have tried COUNTIF, SUMPRODUCT, IF, COUNT, and I cannot
get this to work. I have a spreadsheet that if the following two criteria
are met I want to count it.
Column D - "ASA-2"
Column G - "2"

I am counting how many of ASA-2 (customer identifier-column D) entries have
Level 2 issues (column G).

I have looked throught many of the postings and the formulas keep giving me
0 or NAME# error. Yes I did Ctrl-Shift-Enter. Still nothing.

Thanks.