| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value when two columns are compared
Not sure why you are looking in B?
=SUMIF(A:A,"""",B:B) would get it... if you need to look at somethign in B: =SUMPRODUCT(--($B$2:$B$1000=something),--($C$2:$C$1000<""),$A$2:$A$1000) "MammaFin" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value when two columns are compared
On Sep 2, 3:48*pm, Sean Timmons
wrote: Not sure why you are looking in B? =SUMIF(A:A,"""",B:B) would get it... if you need to look at somethign in B: =SUMPRODUCT(--($B$2:$B$1000=something),--($C$2:$C$1000<""),$A$2:$A$1000) "MammaFin" wrote: 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 Sean Your a star!! I will post another request in 2 min if you get a chance to look at it I'd be really appreciative - I'm a complete novice so any help I get is a real bonus! |
| Reply |
| 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) | |||
Hybrid Mode
