Posted: 12/1/2008 4:01:17 AM EDT
|
I am going to try and explain how my spreadsheet is organized and what I need to do:
Going down the left side is everybody's name and going across the top are the days of the month. Each day occupies two columns. The first column for each day is location traveled to, in which we enter "A", "B", etc., each letter representing a different location with a set distance that is referenced elsewhere in the worksheet. The second column of each day is the person's position, whether "DRV" for driver, "PASS" for passenger, etc. What I need to do is for each person, sum the total miles they've done as a Driver. So I need to go through each cell of the specified row and search for "DRV". Then sum all the cell that preceed each "DRV", which is referenced on a side table. Does that make sense? I've spent 2 hours twiddling with it to no avail. Thanks. |
|
Use the SUMIF Function.
You will most likely need one of these to tally each day, then total them all at the end (you might be able to use another SUMIF for this if it is set up correctly) |