Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF problem
I am trying to use a SUMIF function to add figures from column A when the
corresponding entry in column B (which is a date) is less than a year ago. To try and make things easier I have a formula in c1 which carries out the date calculation =TODAY()-365. I have tried various formulae but have not been able to achieve a successful result - my latest effort is =sumif(b:b,c1,a:a) and I have also tried =sum(if(b:bc1,a:a,0)). Can anyone help ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF PROBLEM | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |