Thread: Can/Should this work?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam Adam is offline
external usenet poster
  
Posts: 287
Default 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

Reply With QuoteReply With Quote