If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|