View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GCRDelphi GCRDelphi is offline
external usenet poster
 
Posts: 13
Default 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