Using Count if - Gives correct value but when data changes the result does not?

[bpulford]

Hi I am using the following formula to count the number of suppliers by post code off a coverage sheet :

=COUNTIF(DetailPostCode!C:C,"All")

=COUNTIF(DetailPostCode!C:C,"AB")

etc

The data is stored as a table so I am able to apply search parameters but when I change the parameters I need the formulas to recalculate. What am I doing wrong? I have tried Calculate Now and Calculate Sheet. But nothing.

Any advice welcomed, thanks.

 

[bpulford]

Found a solution:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($C$2,ROW($C$2:$C$20000)-ROW($C$2),,1)),--($C$2:$C$20000="All"))

or =SUMPRODUCT(SUBTOTAL(3,OFFSET($C$2,ROW($C$2:$C$20000)-ROW($C$2),,1)),--($C$2:$C$20000="AB"))