Count Non-Blank Values in a Table but only for a range

[GCRDelphi]

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.

 

[Pete_UK]

Use this for your first problem:

=SUMPRODUCT((A2:A100>=DATE(2008,1,1))*(A2:A100<=DATE(2008,1,31))
*(C1:C100=""))

I've assumed you have 100 rows, with a heading in row 1 - adjust
ranges to suit your data.

For your second problem:

=SUMPRODUCT((A2:A100>=DATE(2008,1,1))*(A2:A100<=DATE(2008,1,31))
*(B1:B100=F1))

where F1 contains the name you are interested in.

Hope this helps.

Pete

 

[GCRDelphi]

Thanks Pete!

Those worked great!

Thanks again for your help.
--
Gabriel Camarena R.
Delphi Tijuana IT Support

Use this for your first problem:

=SUMPRODUCT((A2:A100>=DATE(2008,1,1))*(A2:A100<=DATE(2008,1,31))
*(C1:C100=""))

I've assumed you have 100 rows, with a heading in row 1 - adjust
ranges to suit your data.

For your second problem:

=SUMPRODUCT((A2:A100>=DATE(2008,1,1))*(A2:A100<=DATE(2008,1,31))
*(B1:B100=F1))

where F1 contains the name you are interested in.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - glad to be of help.

Pete