=SUMIF

K

Kevin

I am trying to use =SUMIF

What I am trying to do is. If B368 is the same as A377 then in B377, I would
like to add F368, G368, H368, I368.

For example if A377 has ABC in it, and B368 has ABC in it, then I would like
B377 to add F368:I368

In B377 I have tried =SUMIF(B368,A377,F368:I368)but it just remains a zero
no matter what values are in F368:I368)

I know I can use this, =SUMIF(B368,"ABC",F368:I368) but this will not work
for me. On any different sheet A377 could be different.

I am using Excel 2007
 
M

muddan madhu

try this

=SUMPRODUCT((B368=A377)*(F368:I368))

or

=IF(B368=A377,SUM(F368:I368),"")
 
P

Pecoflyer

Kevin;199410 said:
I am trying to use =SUMIF

What I am trying to do is. If B368 is the same as A377 then in B377,
would
like to add F368, G368, H368, I368.

For example if A377 has ABC in it, and B368 has ABC in it, then I woul
like
B377 to add F368:I368

In B377 I have tried =SUMIF(B368,A377,F368:I368)but it just remains
zero
no matter what values are in F368:I368)

I know I can use this, =SUMIF(B368,"ABC",F368:I368) but this will no
work
for me. On any different sheet A377 could be different.

I am using Excel 2007
Click to expand...

Try =if(b368=a377,sum(f368:i368),""

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
D

David Biddulph

=IF(B368=A377,SUM(F368:I368),"whatever you want if the condirtion isn't
met")
 
K

Kevin

Thanks for the quick responses, I used the first one
"=SUMPRODUCT((B368=A377)*(F368:I368))" and it worked fine.

Thanks
 
Top