=SUM(($C$1:$C$7>=--"10/01/2004")*($C$1:$C$7<=--"09/30/2005")*(H$1:

[Guest]

I HAVE
‘COPY LINK’ SHEET
COLUMN A COLUMN B COLUMN C D COLUMN E*
1 E5S040001 10/23/2003 MELTON 855
2 E5S050234 03/31/2004 04/20/2005 SMITH 385
3 E5S051234 07/25/2005 02/25/2006 SMITH 215
4 E5S060032 01/25/2006 01/25/2006 MELTON 1

*(COLUMN E has the formula
-------=MAX(IF(ISBLANK(D199),TODAY(),D199)-C199,1)--------to calculate the
number of days the invoice was open)

I have a formula with =SUM(('Copy Link'!$C$1:$C$7638>=--"10/01/2004")*('Copy
Link'!$C$1:$C$7638<=--"09/30/2005")*('Copy Link'!$H$1:$H$7638="MELTON"))
And another with:

=SUM(('Copy Link'!$B$1:$B$7638>="E5S050001")*('Copy
Link'!$B$1:$B$7638<="E5S050500")*('Copy Link'!$H$1:$H$7638="MELTON"))

THEY EACH COME UP WITH DIFFERENT ANSWERS. HELP!!!!!

 

[Bob Phillips]

Try

=SUM(($C$1:$C$7638>=--"01/10/2004")*(IF($C$1:$C$7638<>"",$C$1:$C$7638,TODAY(
))<=--"30/09/2005")*(H$1:$H$7638="MELTON"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Okay, I'll try that. Don't understand what that will give me but my problem
was the two formulas below that ask the same question, but are giving me two
different answers. I don't get it. Sorry, call me dense.