+ Reply to Thread
Results 1 to 2 of 2

conditional addition

  1. #1
    Forum Contributor
    Join Date
    09-19-2004
    Posts
    252

    conditional addition

    I have a txt file that I pulled from our system here at work and it is a list of part numbers in one column (column D), demand for each location month 1 (column E), demand for each location month 2 (column F), demand for each location month 3 (column G) and cluster codes (column C). The cluster codes are groups of locations. I want to write up a conditional statement that will look at the part numbers and the cluster codes and add up a total demand for month 3 a total demand for month 2 and a total demand for month 1. Is there a way that I could do that?

  2. #2
    JE McGimpsey
    Guest

    Re: conditional addition

    Sounds like a pivot table is ideal for this...

    http://peltiertech.com/Excel/Pivots/pivottables.htm

    In article <[email protected]>,
    DKY <[email protected]> wrote:

    > I have a txt file that I pulled from our system here at work and it is a
    > list of part numbers in one column (column D), demand for each location
    > month 1 (column E), demand for each location month 2 (column F), demand
    > for each location month 3 (column G) and cluster codes (column C). The
    > cluster codes are groups of locations. I want to write up a
    > conditional statement that will look at the part numbers and the
    > cluster codes and add up a total demand for month 3 a total demand for
    > month 2 and a total demand for month 1. Is there a way that I could do
    > that?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1