I have an issue where I want to keep the formula in the cell however because I haven't added data yet it displays #NA.
I just want blank shown.
Table 3.PNG
I have an issue where I want to keep the formula in the cell however because I haven't added data yet it displays #NA.
I just want blank shown.
Table 3.PNG
You should be able to wrap your formula with IFERROR. So it would be IFERROR(your formula,what you want to display if error) or specifically,
=IFERROR(SUMPRODUCT(1*(MONTH($C111)=I$98)),"")
Greatly appreciated thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks