Results 1 to 8 of 8

Write a formula to obtain a similar result to a pivot table summary

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Write a formula to obtain a similar result to a pivot table summary

    Hello,
    I am hoping to use a formula instead of a pivot table to get a summary result based on date in one column and summing the quantity from another column. The attached spreadsheet shows an example. I have widget quantities in column J and there are dates in column K. Projects will be added for the next few years, so there will be additional dates down the road.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2018, 08:54 PM
  2. [SOLVED] Sumifs formula not showing correct result, one of criteria is from pivot table
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2017, 07:59 AM
  3. [SOLVED] how to write row formula numbering in calculated field in pivot table
    By JEAN1972 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-05-2017, 11:00 AM
  4. [SOLVED] Extract 9 largest categories - similar to pivot table but need formula
    By Thanks4helping in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-19-2016, 04:32 PM
  5. Formula result to drive Pivot Table Field change
    By Mgiles in forum Excel General
    Replies: 1
    Last Post: 12-21-2011, 08:57 PM
  6. Pivot Table Filter by Formula Result
    By WAW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2010, 06:45 AM
  7. Replies: 2
    Last Post: 04-19-2007, 08:46 PM

Tags for this Thread

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