+ Reply to Thread
Results 1 to 2 of 2

vba code to get Grand total in excel

Hybrid View

nemimeg848 vba code to get Grand total... 01-22-2024, 09:11 AM
JohnTopley Re: vba code to get Grand... 01-22-2024, 09:41 AM
  1. 01-22-2024, 09:11 AM #1
    nemimeg848 is offline
    Registered User
    Join Date
    02-28-2022
    Location
    mumbai
    MS-Off Ver
    ms officeb2010
    Posts
    17

    vba code to get Grand total in excel

    excel file attached...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-22-2024, 09:41 AM #2
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,909

    Re: vba code to get Grand total in excel

    Try
    Formula: copy to clipboard 
    =SUMPRODUCT((D1:D110<>"Net.WT")*(D1:D110=""),(E1:E110))
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting a Grand Average of Counts in a Pivot Table next to the default Grand Total
    By e4excel in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-27-2019, 08:00 AM
  2. Additional grand total to pivot with percent of grand total
    By avism in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-16-2019, 12:26 AM
  3. [SOLVED] Pivot Table Grand total issue need two grand totals
    By alesha711 in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 02-13-2019, 03:02 PM
  4. Only Show Grand Total For One Field, subtotal and grand total for other
    By AMJADJ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-18-2018, 06:10 AM
  5. Need help creating pivot - grand total and grand total as % of column value
    By obionenairobi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2017, 08:00 AM
  6. Code that will add a grand total row
    By n_lindsey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 03:34 PM
  7. [SOLVED] Grand Total Row Not Executing VBA Code as Intended
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2011, 11:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1