Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
sumif Q | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |