| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can/Should this work?
Can the below actually be done? If so, am i just writing it incorrectly as
it doesn't seem to like it? =IF(Data!AG4="USNUAD",DCOUNTA(Data!$1:$9999,"Insti tuition Decisions and Responses",'Calculation Sheet'!$U$45:$X$46),IF(Data!AG4="USNUAB",DCOUNTA(D ata!$1:$9999,"Instituition Decisions and Responses",'Calculation Sheet'!$U$47:$X$48),IF(Data!AG4="PSDNUR",DCOUNTA(D ata!$1:$9999,"Instituition Decisions and Responses",'Calculation Sheet'!$U$49:$X$50),0) Cheers |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can/Should this work?
Not tested, but perhaps
=IF(Data!AG4="USNUAD",DCOUNTA(Data!$1:$9999,"Insti tuition Decisions and Responses",'Calculation Sheet'!$U$45:$X$46), IF(Data!AG4="USNUAB",DCOUNTA(Data!$1:$9999,"Instit uition Decisions and Responses",'Calculation Sheet'!$U$47:$X$48), IF(Data!AG4="PSDNUR",DCOUNTA(Data!$1:$9999,"Instit uition Decisions and Responses",'Calculation Sheet'!$U$49:$X$50),0))) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Adam" wrote in message ... Can the below actually be done? If so, am i just writing it incorrectly as it doesn't seem to like it? =IF(Data!AG4="USNUAD",DCOUNTA(Data!$1:$9999,"Insti tuition Decisions and Responses",'Calculation Sheet'!$U$45:$X$46),IF(Data!AG4="USNUAB",DCOUNTA(D ata!$1:$9999,"Instituition Decisions and Responses",'Calculation Sheet'!$U$47:$X$48),IF(Data!AG4="PSDNUR",DCOUNTA(D ata!$1:$9999,"Instituition Decisions and Responses",'Calculation Sheet'!$U$49:$X$50),0) Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Linear Mode
