Forum Discussion
Add cells together using multiple criteria
Hi. In one cell on sheet 2, I want to add together cells from sheet 1 that have the same value under the column N/C. I know basic excel formulas but think this one needs a few "rules" to be able to give it the correct instruction. I need it to update automatically for future when a N/C is entered under supplier K for example. Thanks.
1 Reply
In C3 on SHEET 2:
=SUMIFS('SHEET 1'!$D$3:$D$100, 'SHEET !'!$C$3:$C$100, B3)
Change SHEET 1 to the real name of that sheet, and expand the ranges if your data extend below row 100.
Then fill down.
