G
Guest
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.
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.