Thread: 3d countif
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
 
Posts: 265
Default 3d countif

In article ,
Mrfish wrote:

Second small issue - I want to copy the formula out across rows and columns,
and currently the D3 part is fixed. Is there an easy change to unfix the
reference?


Try...

=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$2:$A$10&"'!"&C ELL("address",D3)),"D")
)

....where A2:A10 contains the sheet names.

Hope this helps!