Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to filter by month
Hello,
I'm trying to analyze my monthly spending and type of spending. I have a spreadsheet with a column for date, the amount spent and the type of spending, but I'm unable to find a function which can filter each type of spending by month. I've tried the sumif function, but this function does not allow me to sum cells corresponding to other cells WITHIN a certain time period. Instead it only allows me to sum cells corresponding to other cells greater than, less than, or equal to a certain date. I've also tried the conditional summer to build my own function, but I'm unable to make that work either. I'm using Excel 2002. Please help. Thanks, -Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
formula: First and last day in month | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
Filter by month | Excel Discussion (Misc queries) | |||
How can i filter dates based on day of month | Excel Worksheet Functions |