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 this table I have A32:A40 with Supplier names, and B32:B40 with their original costs.
I am trying to get column C32:C40 to show me the final costs by using an IF statement. If row 5 has "supplier name" in column a, add B32+J5.
I can make the if statement work once, but I am trying to get it to add the original cost in B32 plus any value in J5:30 if column a has that specific supplier's name.
Any help can be appreciated.
3 Replies
- 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.
