+ Reply to Thread
Results 1 to 3 of 3

SumProduct with If condition

  1. 07-06-2023, 08:17 AM #1
    alexgempesaw
    alexgempesaw is offline
    Registered User
    Join Date
    10-28-2012
    Location
    Manila, Philippines
    MS-Off Ver
    MS Officel 2010
    Posts
    17

    SumProduct with If condition

    Hi,

    Tried using sumproduct with if condition but it did not work on Excel ver 2013.

    Any tips?

    Thanks in advance! God bless!
    Reply With QuoteRegister To Reply
  2. 07-06-2023, 08:21 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: SumProduct with If condition

    The best tip is to upload a sample file that shows the formula (not working) and some expected results...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 07-06-2023, 08:24 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,962

    Re: SumProduct with If condition

    And please update your forum profile.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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. [SOLVED] Sumproduct with condition
    By aeimisgr in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 01-01-2021, 12:11 PM
  2. SUMPRODUCT with more than one condition
    By nolodani in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-26-2015, 05:02 PM
  3. Sumproduct more than one condition
    By zerbaraa in forum Excel General
    Replies: 1
    Last Post: 02-17-2015, 08:36 AM
  4. SUMPRODUCT using a condition
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 06-20-2014, 04:12 PM
  5. Sumproduct given a condition
    By pickslides in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2014, 12:03 AM
  6. 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
  7. Sumproduct with condition???
    By neda5 in forum Excel General
    Replies: 5
    Last Post: 12-13-2005, 10:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1