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

try this

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

or

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


On Jan 27, 1:23*am, Kevin wrote:
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

Kevin;199410 Wrote:
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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54911

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

"Kevin" wrote in message
...
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

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

Thanks

"muddan madhu" wrote:

try this

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

or

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


On Jan 27, 1:23 am, Kevin wrote:
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