Try this modifcation to your formula placed in cell V3: =IF(A2=A3, V2+U3, U3)

"Jim" wrote:

I am working on an inventory spreadsheet. I am trying to get a total for each
item in a separate column. Each item has multiple rows due to the number of
locations. The formula I have tried to use =IF(A2=A3,V3=V2+U3,V3=U3) does not
work. (A is my item number column, U is my quantity column and V is the
column I am trying to get to be my total for that item number) I am trying to
get it to add the helper row above it if the item numbers match and if they
do not match I want it to use the "u" column. I am probably going about this
in the wrong way so any help is appreciated. Thank you