Unless there is some common factor between the cells excel canno
operate using a sumproduct or sumif formula.
One solution would be to use a helper column to mark the ones you wan
summed.
e.g. if you added a new column A and put a Y next to all the rows yo
want summed you could then use the formula
=sumproduct((a1:a5="Y")*(d1:d5))
(remembering that column c is now column D because of addig the helpe
column
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
