Forum Discussion
IF statement help
I am trying to make a table that corresponds to data in another table. I have column A5:A30 set up with supplier names, and column J5:J30 set up with costs associated with that supplier. Down below...
Thank you! This seems to work for the first value in column J that corresponds with the name in Column A, but does not compute the remaining ones if I have duplicates in column A. Any advice?
=F40+SUMIF(Table1[Supplier],E40,Table1[SC AMOUNT])
Was the formula I found that worked. I needed a sum if formula.