Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
102
Views
Topic starter
Hello all,
Is there an easy way to sum a range based on a spilled range?
Spilled ranges: B4, E2, and E3.
I need to sum the columns E through I, which are manual entries.
based on the part number and only on the same row as the "Prod" in column D.
The highlighted column J is what I want
Thanks in advance!
Posted : 10/02/2023 4:51 pm
It's always easier to help when a workbook is attached over a picture, but have you used #? Something like =SUMIF(B4#,1,$E$4:$I$17) I believe is the syntax. Again, if you need any further help upload a sample of your worksheet that illustrates the problem.
Posted : 11/02/2023 12:15 pm
