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