Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Q
I wish to add up Column B but only those rows (in the column), who's date in Column A is less than today, what formula would I use?
Eg. Col A has dates, Col B has values 25/03/13 - 862 26/03/13 - 1089 27/03/13 - 345 28/03/13 - 6727 29/03/13 - 782 30/03/13 - 827 31/03/13 - 28 01/04/13 - 373 02/04/13 - 87298 As today is 31/03/13, I would only add Col B up as far as 30/03/13 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Q
Hi Sean,
Am Sun, 31 Mar 2013 02:34:58 -0700 (PDT) schrieb : I wish to add up Column B but only those rows (in the column), who's date in Column A is less than today, what formula would I use? Eg. Col A has dates, Col B has values 25/03/13 - 862 26/03/13 - 1089 27/03/13 - 345 28/03/13 - 6727 29/03/13 - 782 30/03/13 - 827 31/03/13 - 28 01/04/13 - 373 02/04/13 - 87298 As today is 31/03/13, I would only add Col B up as far as 30/03/13 try: =SUMIF(A1:A100,"<"&TODAY(),B1:B100) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Q
Thanks, works a treat
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|