The title may seem a little bit simpler than what I need. What I have is a sumif formula on sheet2 that looks on Sheet1 and adds all the cells that correspond with the word "banana". This works fine. What I am looking for now is a formula that will allow me to look into that sumif formula (or the ranges in the sumif formula) and if there is a blank cell that corresponds with the word "banana", then a statement of "Pricing not available" will generate in a cell on sheet2. I'm sure there is a way to figure this out on my own, but my minds elsewhere and i just can't focus. Any help is appreciated.
Bookmarks