COUNTIF+ use in Excel

October 3, 2011 at 05:30:51
Specs: Windows 7
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.


See More: COUNTIF+ use in Excel

Report •

October 3, 2011 at 07:39:44
Without knowing what other data you have in the target cells something like this might work:


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


Report •
Related Solutions

Ask Question