I am using a formula: =COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 25%)+COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 50%)+COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 75%)+COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 100%) It looks a mess due to linking to another worksheet (FRICE-RAW-DATA), what it is basically saying is that if the value 25% appears in cells AC31:AC34, count 1. So if it appears 4 times the count will be 4 etc.

It then does this with any values 25, 50, 75, or 100% to count 1. So if in 31-34 we have 25, 25, 50, 25 the count should simply be 4.

Is it possible to make this look less messy and simply have something which means.

=COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 25-100%

Without knowing what other data you have in the target cells something like this might work: =COUNTIF('FRICE-RAW-DATA'!AC31:AC34, ">25%")

Note the parentheses around the Greater Than symbol and the 25%.

MIKE

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History