| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| an excel formula for specific conditions | Excel Worksheet Functions | |||
| multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Threaded Mode
