Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Non-Blank Values in a Table but only for a range
I have a table of values like the following:
Column A=Date B=Name B=Problem C=Solved Date D=Solution I need to count the blank from column C but only from a certain date range in clumn A, for example count all the blanks in clumn C but only from the rows that have the date in clumn A between 1/1/2008 to 1/31/2008. Also with the same table count how many times a Name in column B apears but also only from the rows that have the date in clumn A between 1/1/2008 to 1/31/2008. Thank you for you help. -- Gabriel Camarena R. Delphi Tijuana IT Support |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count zeros and not blank in selected range? | Excel Worksheet Functions | |||
cell is blank then dont count range | Excel Discussion (Misc queries) | |||
Pivottable won't count blank values | Excel Discussion (Misc queries) | |||
Need assistance: Count non-blank within date range | Excel Worksheet Functions | |||
count of (blank) pivot table | Excel Discussion (Misc queries) |