Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of values based on different criteria
I have a column (lets say column A) that has a dropped down list of
'terminated' or 'completed' (let say from row 1 to row 5), and I have another column (Column B) that I enter a code of 'HB' for home buying (there are blank cells); then my last column (column C) has an amount. Now, I would like to know how much is the total (sum) for the terminated and the total for completed. Any help will be appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum unique values based on criteria | Excel Worksheet Functions | |||
Returning all values based on 2 criteria... | Excel Discussion (Misc queries) | |||
Looking up values based on two criteria | Excel Worksheet Functions | |||
Sum of Values Based on Criteria in Another File | Excel Worksheet Functions | |||
adding values based on criteria | Excel Worksheet Functions |