View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MammaFin MammaFin is offline
external usenet poster
 
Posts: 3
Default 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