Sorry, began posting earlier and hit send by mistake!

I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc

Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"

Any thoughts?

Hi
I assume that your dates are text and not real dates format,
otherwise you need a different formula
try this formula
=SUMIF(A2:A10,"April*",B2:B10) or

use a cell to hold the reference. eg in C2,you need to type April*
=SUMIF(A2:A10,C2,B2:B10)

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Mark" wrote:

Sorry, began posting earlier and hit send by mistake!

I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc

Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"

Any thoughts?

If cells in column A have a date format :
=SUMPRODUCT((A1:A100<=TODAY()+1)*(MONTH(A1:A100)=4 )*B1:B100)
Daniel

Sorry, began posting earlier and hit send by mistake!

I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc

Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"

Any thoughts?

If you put real dates in column A, then you can use a formula like this:

=SUMIF(A:A,"<="&TODAY(),B:B)
to sum all the values in column B where column A is less than or equal to today.

But I'm not sure what 1st month means.

If you wanted everything that happened between the first of the current month
until today, you could use:

=SUMIF(A:A,"<="&TODAY(),B:B) - SUMIF(A:A,"<="&(TODAY()-DAY(TODAY())),B:B)

=today()-day(today())
will give the last day of the previous month.

So the formula is just summing _everything_ that happened through today and then
subtracting stuff that happened last month and before.






Mark wrote:

Sorry, began posting earlier and hit send by mistake!

I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc

Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"

Any thoughts?

--

Dave Peterson