+ Reply to Thread
Results 1 to 5 of 5

Calculated Field to Multiple Columns and Values

  1. #1
    Registered User
    Join Date
    08-17-2017
    Location
    San Francisco, CA
    MS-Off Ver
    2016
    Posts
    26

    Calculated Field to Multiple Columns and Values

    Hi Forum I'm trying to figure out how to multiply my column values to the values counts. I manually enter these on the last three columns (yellow highlights) Is there a calculated field I can use for this?


    Thanks,
    Attached Images Attached Images

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Calculated Field to Multiple Columns and Values

    Its better attach your sample workbook. Refer yellow banner on top.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    08-17-2017
    Location
    San Francisco, CA
    MS-Off Ver
    2016
    Posts
    26

    Re: Calculated Field to Multiple Columns and Values

    Excel Attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-17-2017
    Location
    San Francisco, CA
    MS-Off Ver
    2016
    Posts
    26

    Re: Calculated Field to Multiple Columns and Values

    Bump. Any help!? Thanks.

  5. #5
    Registered User
    Join Date
    08-17-2017
    Location
    San Francisco, CA
    MS-Off Ver
    2016
    Posts
    26

    Re: Calculated Field to Multiple Columns and Values

    Quote Originally Posted by raychow22 View Post
    Hi Forum I'm trying to figure out how to multiply my column values to the values counts. I manually enter these on the last three columns (yellow highlights) Is there a calculated field I can use for this?


    Thanks,

    Anyone knows how to match and return column value... let's say for row 0000100... if the value (2) is on column for (1); then it returns to column (1)..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-30-2019, 03:35 PM
  2. calculated field for last 2 columns
    By raja_puligadda in forum Excel General
    Replies: 5
    Last Post: 01-10-2017, 08:16 AM
  3. Pivottable Calculated Field based on multiple values
    By warrior2411 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-10-2016, 12:27 PM
  4. [SOLVED] A pivot table field calculated using other field values as fields?
    By chrisf78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2015, 03:08 AM
  5. [SOLVED] Excel 2007 Auto sorting rows by multiple columns that contain values that are calculated
    By bobatron83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2014, 01:32 PM
  6. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  7. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM

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