Sum if ONLY all the cells have a value?
- by Mike
Hi
I need to sum 9 cells of data, each one on a separate sheet, but always in the same location. I only want a figure returned when all the cells have data, even if it's a 0. But, if one of the cells is blank I want a blank return.
I'm trying to get my head around, making it up actually, where the IFs and ISBLANK and SUMS would go. Any pointers…