Hello!
I need to sum a specific cell that is in all the worksheets in a book I am making (ie lets say I have week 1, week 2, week 3 and need to add whatever is in K6 in each one of those sheets). I know how to do this. However, I cannot figure out how to do this while ignoring blanks! I need to ignore blanks because it counts the blanks and I get a zero as a return which messes up an average that uses that SUM.

Please help before my brain explodes and I start speaking in excel codes.

The formula I am using atm is
=SUM('WEEK 1'!M9,'WEEK 2'!M9,'WEEK 3'!M9,'WEEK 4'!M9,'WEEK 5'!M9) and it returns as 0

Whoever finds a fix first is a =HERO(A1:A∞, "MY")