| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting blanks, either 1, 2 or 3
I'm counting blank cells with this formula:
=COUNTIF(Y3:Y223,"") In column X, I have this formula =LEFT(S74,1), which results in either a 1, 2 or 3 How could I count the blank cells that correspond with the 1's, the 2's & the 3's ? Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| Counting Blanks | Excel Worksheet Functions | |||
| If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
| Counting rows of blanks across certain columns | New Users to Excel | |||
| linking files with blanks | Excel Discussion (Misc queries) | |||
Threaded Mode
