Returning a value when two columns are compared

  • Thread starter Thread starter MammaFin
  • Start date Start date
M

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
 
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)
 
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)
Click to expand...


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!
 
Back
Top