Can/Should this work?

[Adam]

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,"Instituition Decisions and
Responses",'Calculation
Sheet'!$U$45:$X$46),IF(Data!AG4="USNUAB",DCOUNTA(Data!$1:$9999,"Instituition
Decisions and Responses",'Calculation
Sheet'!$U$47:$X$48),IF(Data!AG4="PSDNUR",DCOUNTA(Data!$1:$9999,"Instituition
Decisions and Responses",'Calculation Sheet'!$U$49:$X$50),0)

Cheers

 

[Bob Phillips]

Not tested, but perhaps

=IF(Data!AG4="USNUAD",DCOUNTA(Data!$1:$9999,"Instituition Decisions and
Responses",'Calculation Sheet'!$U$45:$X$46),
IF(Data!AG4="USNUAB",DCOUNTA(Data!$1:$9999,"Instituition Decisions and
Responses",'Calculation Sheet'!$U$47:$X$48),
IF(Data!AG4="PSDNUR",DCOUNTA(Data!$1:$9999,"Instituition 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)