| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using SUMIF for a financial value AND a DATE
Hi, I'm trying to use a SUMIF formula to add up 2 criteria.
1) financial value above £5 AND 2) before a date of 1/2/2008 Using a simple table example.... £10 2/3/2008 £5 12/1/2008 £8 10/12/2007 £12 1/1/2007 I would be looking for an formula that gave me £20. I think its something to do with ... =sumif(-- .... type equation, but I cant work out exactly what it is , or how I do the BEFORE DATE OF 1/2/2008 bit. Thank you very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert date to financial year format 2006-07 | Excel Worksheet Functions | |||
| How to compare a date with financial year | Excel Discussion (Misc queries) | |||
| SUMIF for date | Excel Discussion (Misc queries) | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| sumif based on date | Excel Worksheet Functions | |||
Threaded Mode
