AJP Excel Information
RE: Yes No count using named range
Named formula
ChtData:
=CHOOSE(ROW(Sheet1!$1:$2),COUNTIF(Sheet1!$A$2:$A$21,"Yes"),COUNTIF(Sheet1!$A$2:$A$21,"No"))
Chart Series formula
=SERIES(,{"Yes","No"},ng54.xls!ChtData,1)
Example file
Created August 2004
Last updated 5th August 2014
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope