In the spreadsheet I set up I have several columns/rows but only 3 of them
are giving me trouble. The 3 columns are PRODUCT , P/L (pump or load) , and
TOTALS that are giving me my trouble. We have several different products and
most are both loaded or pumped at different times during the month. I have to
keep a running total for daily, weekly, monthly and yearly for all product
handling at our facility.

How can I get my spreadsheet to count the number of individual
loading/pumping of each product. At the end of the sheet I SUM the column to
find the totals for all handlings in a month. Right now after I enter the
info in the row for a product I have to go up the sheet and count the # of
times the product had been pumped so far in the month and enter it in the end
row, this done for each product and loading or pumping. We have 20 plus
different products and all are either loaded or pumped during a give month so
trying to track all of the different product handlings is a chore.

EX. we will have 20 gas loading, 25 gas pumping, 12 diesel pumping, 8 diesel
loading, 45 kero loading, 14 vgo pumping and 23 vgo loading for a total of
147. All scattered thur out the month that I have to track daily.

We used to do this with a tablet and pen but I have gotten Excel to do alot
of it just not this part.