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