Consider using a Pivot Table to do the analysis. See:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200793
"sloeffler" wrote:
I am working on a "charge sheet" for hospital use. So far, I have a pretty
simple sheet that looks like this
A B C D
E F
1 Name Acct # Charge code Direct units Indirect Units Forms
units
2
3
*Column C is a drop down menu pulling from a list on wksht 2. I already
have the sum function set up to get daily totals of direct units and
indirect. BUT I need: To be able to, after this information is populated,
analyze the data so I can say how many direct, indirect, and forms units are
attached to each code. Can anyone help with this?