Works OK for me. Maybe the cells don't exactly equal 100?

I would write this: "= 100" simply as 100:

=COUNTIFS('FEB FY10'!$P$7:$P$126,"Australia",$BG$7:$BG$126,100)/C19

--
Biff
Microsoft Excel MVP


"ottodesque" wrote in message
...
I have created the formula =COUNTIFS('FEB
FY10'!$P$7:$P$126,"Australia",$BG$7:$BG$126,"= 100")/C19. The problem is
that cells BG7:BG126 contain a formula so the formula returns a value of 0
as
it does not see the results of the formula in BG7:BG126. How can I make
this
work