# 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. =COUNTIF('FRICE-RAW-DATA'!AC31:AC34, 25-100%

See More: COUNTIF+ use in Excel

#1
October 3, 2011 at 07:39:44
 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

Report •
Related Solutions