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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!!!
 
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)
 
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.
 
Back
Top