Formula Question

M

Mark

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?
 
F

Francis

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
 
D

Daniel.C

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

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top