| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count data in one column indicated by data in another column
Column A holds "X" or "" (blank). Column B holds "1", "2", or "3".
I need to count the number of 1s, 2s, and 3s, in column B when the cell in column A is blank. I've tried several variations of IF, AND, & COUNTIF - can't get anything to work. Have also tried many variations of SUMPRODUCT found in other posts. None are working for me. Can you please help? Is there a way to do this? Thank you! -- Carol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
| HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
| I need to count data in one colum based on data in another column | Excel Worksheet Functions | |||
| How do I count or display unique data in a column? | Excel Worksheet Functions | |||
Threaded Mode
