Split from: https://www.mrexcel.com/forum/excel-questions/388098-sumif-multiple-rows-single-criteria.htmlMaybe this:
I need to do the same as this user, but with the difference being that the rows aren't in a single range.
So I'm basically looking at doing something like:
So in the example, based on the criteria matching in row 14, I'd want to add up the cells of rows 184,185,200, and 203.
The example formula I typed won't work - anyone know how I should do it?
Last edited by a moderator: