+ Reply to Thread
Results 1 to 11 of 11

Summing pivot fields where value is 1

Hybrid View

Leanne_B Summing pivot fields where... 05-13-2013, 02:13 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 02:47 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:02 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:04 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:07 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:11 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:16 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:22 PM
Leanne_B Re: Summing pivot fields... 05-14-2013, 01:41 PM
judgeh59 Re: Summing pivot fields... 05-14-2013, 01:48 PM
Leanne_B Re: Summing pivot fields... 05-14-2013, 02:00 PM
  1. #1
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Summing pivot fields where value is 1

    I see your point....you could use a COUNTIF function to count the "1"s....then when you update all your PT it should flow to the pivot chart....does that make sense?
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  2. #2
    Registered User
    Join Date
    05-13-2013
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Summing pivot fields where value is 1

    Yes, it makes sense. Using a COUNTIF was something I was considering, but I couldn't figure out how to implement it properly. If you know how it should be done, I could use some guidance.

+ 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