| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value when two columns are compared
Hi All, Thanks in advance for any help you can give, I'm tearing my hair out trying to figure this one out. I am looking to sum the values in column A IF a search in column B has corresponding values in column C. So as per the example below the result should read: 665,600.0 Size LUN Name Mirror 153,600.0 MB LUN 0 153,600.0 MB LUN 1 LUN 27 153,600.0 MB LUN 2 256,000.0 MB LUN 3 256,000.0 MB LUN 4 LUN9 256,000.0 MB LUN 5 256,000.0 MB LUN 6 LUN4 Kind regards, Fin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning one arguement from several columns | Excel Worksheet Functions | |||
| Matching Three columns and returning a value | Excel Discussion (Misc queries) | |||
| comparing columns and returning max value | Excel Discussion (Misc queries) | |||
| Returning a Value by Matching Two Columns of Data | Excel Worksheet Functions | |||
| I need to match multiple columns before returning a value | Excel Discussion (Misc queries) | |||
Threaded Mode
