Here is an example of the data I receive for total time incurred for specifc delays during production. The issue I have is I only want to total specific headings and omit others. To complicate this further is if more codes are added the columns may not be the same the next time I generate the report. So how do I do this?
Codes Total for AB, TR, AS
AB TS IB TR AS VD VB
1.5 1.1 1.6 .9 1.8 4
Last edited by dsschaser; 09-24-2012 at 05:07 PM.
This didn't display well so the totals were:
AB - 1.5
TS -1.1
IB -
TR -1.6
AS - .9
VD -
VB - 1.8
Ignor attachment, I can't figure out how to attach
Last edited by dsschaser; 09-24-2012 at 02:41 PM.
Okay, like you said, the attachment doesn't seem to be related to your question.
What exactly are you totaling? anything in Column with Header TS for example or is there some other criteria? How is your data set up (best to attach that example (Go Advanced>Manage Attachments))?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Perhaps..
=SUM(SUMIF(A1:G1,{"AB","TR","AS"},A2:G2))
Life's a spreadsheet, Excel!
Say thanks, Click *
That did it! thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks