D
driller
hello,
my "TEMPLATE" worksheet contains many if/sumproduct/index/match/lookup
formulas with dozens of criteria. The template (given to me) consists of some
merged cells which contains formulas and/or text.
my print_area B1:J63
i do not know if there is a formula to just simply count the error result
(e.g #N/A,#VALUE,etc)..
something like on A1=count(iserror(B1:J63))...
A1 will be called by a Macro that if it is ">0", the print command will be
ignored!
hope this is a simple task.
regards,
driller
my "TEMPLATE" worksheet contains many if/sumproduct/index/match/lookup
formulas with dozens of criteria. The template (given to me) consists of some
merged cells which contains formulas and/or text.
my print_area B1:J63
i do not know if there is a formula to just simply count the error result
(e.g #N/A,#VALUE,etc)..
something like on A1=count(iserror(B1:J63))...
A1 will be called by a Macro that if it is ">0", the print command will be
ignored!
hope this is a simple task.
regards,
driller