Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup to count non blank cells
Hello
Can anyone tell me what formula I need please? I have 2 tables, both have our sites listed in column A. I want the second table to count how many non blank cells there are in column B for each site in table 1. The tables look somthing like this: Table 1: Site 1 Data Site 2 Data Site 2 Data Site 2 Site 3 Site 4 Data Site 4 Site 4 Table 2: Site 1 Site 2 Site 3 Site 4 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count from Blank & Non-Blank Cells | Excel Discussion (Misc queries) | |||
Count the non blank cells | Excel Worksheet Functions | |||
Help getting count of non-blank cells | Excel Discussion (Misc queries) | |||
Do Not count blank cells | Excel Discussion (Misc queries) | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions |