Thank you Ford for the response, I got lost at the range name and how to use that. I attached a sample workbook - In the summary sheet, I want to add b4 thru 8-24 to 8-26 if d4 in that sheet =3 and e4 in that sheet =22.5. So even more simply, if in sheet 8-24 d4=3 and e4=22.5 then it would add that value, then the same for 8-25 and 8-26.
Bookmarks