ExcelBanter - SumIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SumIF (https://www.excelbanter.com/excel-programming/405966-sumif.html)

Arnie

SumIF

Can you use <=Today() for criteria if my Range A2:A29 (are Dates) and the
column i want to total is B2:B28

Formula is =SUMIF(A2:A30,"<=TODAY()",B2:B30)

The reult is £0 when i expected it to have added up the amounts (01/02/08 -
12/02/08 in Column A ) in Column B

Mike H

SumIF

Arnie,

You hit the cossbar you were so close!! Try this

=SUMIF(A2:A30,"<="&TODAY(),B2:B30)

"Arnie" wrote:

Can you use <=Today() for criteria if my Range A2:A29 (are Dates) and the
column i want to total is B2:B28

Formula is =SUMIF(A2:A30,"<=TODAY()",B2:B30)

The reult is £0 when i expected it to have added up the amounts (01/02/08 -
12/02/08 in Column A ) in Column B

Arnie

SumIF

DOOOOOHHHHHHH Ta V Much

"Mike H" wrote:

Arnie,

You hit the cossbar you were so close!! Try this

=SUMIF(A2:A30,"<="&TODAY(),B2:B30)

"Arnie" wrote:

Can you use <=Today() for criteria if my Range A2:A29 (are Dates) and the
column i want to total is B2:B28

Formula is =SUMIF(A2:A30,"<=TODAY()",B2:B30)

The reult is £0 when i expected it to have added up the amounts (01/02/08 -
12/02/08 in Column A ) in Column B

All times are GMT +1. The time now is 10:33 AM.