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

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

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!