sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 25 Sep 2007 16:04 GMT

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:A340>C344)*(A4:A340<=C345)*F4:F340)
Help, please.
kelly :)

Reply to this Message

Peo Sjoblom - 25 Sep 2007 16:11 GMT

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:A340>I1),--(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

Signature

Regards,

Peo Sjoblom

>I have a spreadsheet with a list of invoice dates and the amounts due. At
> the bottom, I have due dates a week apart
[quoted text clipped - 12 lines]
> Help, please.
> kelly :)

Reply to this Message

Kelly - 25 Sep 2007 17:22 GMT

thank you very very much!!

> The formula does work so there can be either of these 2, the dates are seen
> as text by Excel
[quoted text clipped - 29 lines]
> > Help, please.
> > kelly :)

Reply to this Message