Replies (7)
Please login or register to join the discussion.
If I have understood
the OP correctly, I think SUMIFS will be difficult (not necessarily impossible) because it applies multiple criteria to a range or ranges rather than adding items from the range meeting different criteria. i.e. the criteria are "AND" rather than "OR" and it restricts rather than expands selection.
sumif()
Used normally, the result of a sumif is just a number, so of course you can add them together.