Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to find a way to create a formula that calculates the following:
If the value of a cell in column A equals a certain criteria, what is the total value of the cells in column B that meet the crtieria in column A. For example: A B 40 120.00 40 30.00 50 40.00 60 50.00 Where you see 40 in the column A, I want to know the total value of column B, where 40 appers in the corresponding cell in column A. Can this be achieved with a formula? -- Kind regards Sara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |