Returning a value when two columns are compared

[MammaFin]

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 Timmons]

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]

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)

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!