I attached the file and highlighted the cells in orange for what I'm trying to find.
Basically I am trying to find the Min of a bunch of numbers that are paired together in 2s.
For example: Cell 1: Price for Salt
Cell 2: Price for Snow Removal
Cell 4: Price for Salt
Cell 5: Price for Snow Removal
Cell 7: Price for Salt
Cell 8: Price for Snow Removal
I'm trying to find the min price of (Price for Salt + Price for Snow removal)
However, some of my cells are blank thus my final result is "0' which I don't want.
it sounds confusing but if you see in my attached document it will make a lot more sense.
Bookmarks