Forum Discussion
Solved
Formula help: Sum of cells with multiple entries
I believe it is the sumifs formula that I will use, but I don't know if there is a better way or how to go best about it. I am looking to add the total of cells under incentive amount but based on em...
You can use
=SUMIFS(incentive_range, email_range, email, type_range, "<>Parking")
You might also enter the following formula in a cell elsewhere:
=UNIQUE(email_range)
and in the cell next to it
=SUMIFS(incentive_range, email_range, unique_email_cell#, type_range, "<>Parking")
The # after the unique_email_cell specifies the spill range of the UNIQUE formula.
You can use
=SUMIFS(incentive_range, email_range, email, type_range, "<>Parking")
You might also enter the following formula in a cell elsewhere:
=UNIQUE(email_range)
and in the cell next to it
=SUMIFS(incentive_range, email_range, unique_email_cell#, type_range, "<>Parking")
The # after the unique_email_cell specifies the spill range of the UNIQUE formula.
- Thank you so much!! You helped me a lot today.
