I am using Excel 2007 to analyse soem data. I need to get the total amount based on some criteria. I know SUMIFS can be used for this. Please see the attached excel sheet. I am using the below formula to calculate the total amount.
=SUMIFS(C2:C16,A2:A16,"Jan",B2:B16,"Fri")+SUMIFS(C2:C16,A2:A16,"Jan",B2:B16,"Mon")+SUMIFS(C2:C16,A2:A16,"Feb",B2:B16,"Fri")+SUMIFS(C2:C16,A2:A16,"Feb",B2:B16,"Mon")
This is only an example. The actual calculation I am trying to do involve more than 500 rows. So I need a better solution.
This is what i am looking for:
SUM Amount if ( (Month is equal to 'Jan' or 'Feb') AND (Day is equal to 'Mon' or 'Fri')
That is, a formula in which i can give multiple values for one range. Can some one help me with an Excel 2007 formula for this?
Bookmarks