| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with two criteria including a date range
I have a spreadsheet of my personal spending and I want to sum up how much I
have spent on a) luxuries and b) essentials ("l" and "e") in a particular date range. I can get it to work if I ignore either the date range criteria: =SUMIF(G2:G1228, "e",D2:D1228) or the essentials/luxuries criteria: =SUMIF(A2:A2222,"<="&DATE(2007,2,11),D2:D2222)-SUMIF(A2:A2222,"<"&DATE(2007,1,12),D2:D2222) but how do I do both together? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use Date range function in Sum(if....) | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
| Sum range of values that meet date criteria | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
Threaded Mode
