I have a large data table, and I want to find the sum for certain data that fits a few criteria.
Here is a simplified example:
1 Type Dates Amount (headings)
2 shirt 1/4/2013 $10
3 pants 6/8/2013 $20
4 shirt 3/9/2013 $15
Is there a compound formula or macro that could find the sum of money if it is a "shirt" and is within the first 3 months of the year?
The answer should equal $45 (10+15)
I would appreciate this soooooo much!!!!
Find the sum of data that has multiple conditions in Excel