Situation: Student database, hundreds of names and other criteria.
Project: Create graphs/charts from data
Problem: can I/how do I use functions like COUNTIF to extrapolate the
values for the chart with out having to count them manually?
i.e. one colum has country of origin, in the worksheet I can
use
=COUNTIF(A2:A111,"Canadian") and get the total # of
Canadians
id there a way to get the chart wizard to do this?
All help appreciated.