View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gayla
 
Posts: n/a
Default COUNTIF Formula in Excel with two conditions

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.