Pretty good excel user, but frustrated. Here is my situation...and I
apologize in advance for the "silliness" of it all, but I cannot use my
real example...here goes:
I have 8 worksheets each with a different kind of vehicle (e.g. Ford,
Chevy, Dodge, Honda, Toyota, BMW, Mercedes, VW). On each of the
worksheets, I have two adjacent columns: "Errand" for what kind of
errand the car was used for (with drop-down lists in each cell in the
column for the user to select one of the following: groceries,
transportation, cargo, other), and "Support" for who the car was
supporting when it did the aforementioned errand (with a drop-down list
in each cell in the column for the group of people supported: parents,
friends, collegues, teachers).
Now then, I have a "reference" worksheet at the back of the workbook
with two different areas to tabulate 1. how many times each specific
car does a particular errand, and 2. how many times a specific car
supports a particular group. What I cannot figure out how to do
(keeping in mind I have 8 worksheets from which to gather data) is how
to create another area on the "reference" sheet to calculate how many
times each errand is run for each particular group of people. For
example, I need to see how many times I've had to do "grocery" runs for
"collegues" or how many "cargo" runs I've had to do for "parents" (and
so on...) between all 8 cars.
I've been racking my brains to the point where I can no longer think
straight and I've read all the help files Excel has to offer but to no
avail.
Can anyone help?
Thank you very much in advance!
- John


--
jgn2112
------------------------------------------------------------------------
jgn2112's Profile: http://www.excelforum.com/member.php...o&userid=36175
View this thread: http://www.excelforum.com/showthread...hreadid=559542