Forum Discussion
Sums between sheets with #N/A Included
I have 5 sheets all the same, i want to add the same cell in all five sheets D4. But some of them will include #N/A. Is this possible?
Hi Colin,
Yes, this is possible!
Let's suppose that the five sheets are named this way:
Sheet1, Sheet2...
So you can put this formula in any sheet:
=AGGREGATE(9,6,Sheet1!D4,Sheet2!D4,Sheet3!D4,Sheet4!D4,Sheet5!D4)