sumif
The formula does work so there can be either of these 2, the dates are seen
as text by Excel
or the values in F4:F340 are text
Your formula can be rewritten as
=SUMPRODUCT(--(A4:A340I1),--(A4:A340<=J1),F4:F340)
however I just tested your formula and it does what it should do
Test for text as follows
=ISTEXT(A4)
copy down if you get and TRUE those values are text, do the same for the F
column
--
Regards,
Peo Sjoblom
"Kelly" wrote in message
...
I have a spreadsheet with a list of invoice dates and the amounts due. At
the bottom, I have due dates a week apart
08/03/07
08/10/07
08/17/07
08/24/07
08/31/07
If the invoice date is equal to or less than 08/10/07 and greater than
08/03/07, I would like to include it in my SUMIF. Everything I have tried
(sumif and sumproduct) have produced $0 values.
Here is an example of the latest formula I've found here on the discussion
boards that I've tried to use.
=SUMPRODUCT((A4:A340C344)*(A4:A340<=C345)*F4:F340 )
Help, please.
kelly :)
|