Thread
:
formulas
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
formulas
tankman,
If I follow you correctly it sounds to me as if you want SUMPRODUCT() read
up about it at:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
(one of many sites I just happend to Google to that one first)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"tankerman" wrote in message
...
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann