| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
applying formula
I want to sum only some of the cells in a column, base on the date those
payments are due. For example, add up all the bills over 60 days old. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
applying formula
Pat,
Try: =SUMIF(H1:H12,"<"&TODAY()-60,I1:I12) Adjust to suit your own ranges. -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Pat N." <Pat wrote in message ... I want to sum only some of the cells in a column, base on the date those payments are due. For example, add up all the bills over 60 days old. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying a formula to an entire column | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
Linear Mode
