Total based on string position and expiration date

My Excel 2007 sheet has 5 columns - Milk, Cheese, Yogurt, Bread, and Expiration Date. Each row has one string "X" with a corresponding expiration date. I need help calculating the total amount of each expired item. The sheet will contain 400 rows.



Thank you for taking the time to help.

Can you upload a spreadsheet with both data and results of what you are trying to do?

You can use this formula =COUNTIF(E2:E15,">="&G1)

the E2:E15 section should be updated as needed to the range containing expiration dates. G1 would need to be updated with the date you are checking for expriations - most likely you should use TODAY().

This will count each row that is expired. I am not sure this is what you are trying to do.