Thread: =SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default =SUMIF

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