I have a simple problem and I don't know how to solve this issue. I've tried the sumifs function but it will only allow using multiple criteria from *different* ranges...not from the same range.
So I have two columns. One with names and the second column with prices. I want to selectively sum the prices from criteria using the names column choosing only certain names and ignoring the rest. How can I do this? Sumif only allows one criteria for one range while sumifs only allows mutliple criteria using different ranges. I need a solution to sum multiple criteria from *one* range only. Is there a solution for this?
Thanks in advance.
Bookmarks