Results 1 to 5 of 5

Need a help with SUMPRODUCT in a Matrix Table Lookup

Threaded View

ZANDRY10085 Need a help with SUMPRODUCT... 01-08-2020, 04:00 AM
AliGW Re: Need a help with... 01-08-2020, 04:08 AM
AliGW Re: Need a help with... 01-08-2020, 04:09 AM
ZANDRY10085 Re: Need a help with... 01-08-2020, 04:21 AM
AliGW Re: Need a help with... 01-08-2020, 04:22 AM
  1. 01-08-2020, 04:00 AM #1
    ZANDRY10085 is offline
    Registered User
    Join Date
    01-08-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    36

    Need a help with SUMPRODUCT in a Matrix Table Lookup

    Hello everyone,

    I am trying to come up with a way to get a total count based on this formula "=SUMPRODUCT(--($A$2:$A$13=$A19);F$2:F$13)", instead of using the exact range for Mei 2019 "F$2:F$13", i want to use the range from all month in the formula with the same result from that formula.


    sry for my bad english, thx for your help
    Attached Files Attached Files
    Last edited by AliGW; 01-08-2020 at 04:07 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Sumproduct with multiple variants - Help! I'm a newbie to sumproduct
    By KIGeorge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2019, 01:21 AM
  2. Combine sumif/sumproduct or sumproduct with multiple criteria
    By sab128 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2018, 08:25 AM
  3. [SOLVED] Use sumproduct to further parse a sumproduct calculation
    By Araise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2015, 08:17 PM
  4. Count SUMPRODUCT Members / Average of SUMPRODUCT
    By Shingaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 03:59 PM
  5. Lookup or Sumproduct or if condition with sumproduct and vlookup
    By angie.chang in forum Excel General
    Replies: 1
    Last Post: 05-19-2012, 02:54 AM
  6. [SOLVED] Sumproduct with Multiple (Header) Criteria - Sumproduct, Index, Match
    By dluhut in forum Excel General
    Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  7. Using a SumProduct Count to find a SumProduct Total?
    By XL021710 in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 08:31 AM

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