| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a formula to count something like this....
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 -- ***** birds of the same feather flock together.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a formula to count something like this....
Try this:
=SUMPRODUCT(--(ISERROR(B1:J63))) -- Biff Microsoft Excel MVP "driller" wrote in message ... 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 -- ***** birds of the same feather flock together.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a formula to count something like this....
thanks Sir Valko,
i did! Looking forward to browse the MVP webpage <updated! regards, driller -- ***** birds of the same feather flock together.. "T. Valko" wrote: Try this: =SUMPRODUCT(--(ISERROR(B1:J63))) -- Biff Microsoft Excel MVP "driller" wrote in message ... 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 -- ***** birds of the same feather flock together.. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a formula to count something like this....
You're welcome!
To date, that's been the easiest question you've posted! <g -- Biff Microsoft Excel MVP "driller" wrote in message ... thanks Sir Valko, i did! Looking forward to browse the MVP webpage <updated! regards, driller -- ***** birds of the same feather flock together.. "T. Valko" wrote: Try this: =SUMPRODUCT(--(ISERROR(B1:J63))) -- Biff Microsoft Excel MVP "driller" wrote in message ... 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 -- ***** birds of the same feather flock together.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
| Trying to construct a count count formula | Excel Discussion (Misc queries) | |||
| COUNT Formula?? | Excel Discussion (Misc queries) | |||
| Need a Count Formula | Excel Worksheet Functions | |||
| Count If formula | Excel Discussion (Misc queries) | |||
Linear Mode
