SumIF

A

Arnie

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
 
M

Mike H

Arnie,

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

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

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

Similar Threads

How do I add numbers in two column based on the date in another? 2
Supressing a #VALUE! error returned? 3
Working with ranges in arrays... or an introduction to arrays 5
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
SUMIF with the criteria range 4
Formula to use in Macro 5
Capture match and update EXCEL 2003 2
convert range of years to series 10

Top