+ Reply to Thread
Results 1 to 2 of 2

Using Sumproduct or sumifs when a cell has a formula

  1. 10-15-2013, 03:58 PM #1
    cartica
    cartica is offline
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Using Sumproduct or sumifs when a cell has a formula

    Hi-

    I am trying to use a sumproduct, but it returns a zero. Would this have anything to do with the fact that the numbers in the cells in column S are a formula? If so, any suggestions to fix?

    Thanks

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-15-2013, 04:02 PM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Using Sumproduct or sumifs when a cell has a formula

    Hi,

    Looks fine to me. Are you sure that there aren't any text and/or error values in S9:S31?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    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. SUMIFS or SUMPRODUCT repeat formula for all occurrences of each employee
    By wmk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-29-2013, 09:45 AM
  2. Help with SUMIFS/SUMPRODUCT Formula? for date/time
    By auswtz in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-31-2013, 09:47 AM
  3. [SOLVED] Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)
    By markl41 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2012, 02:24 PM
  4. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  5. [SOLVED] =SUMPRODUCT(SUMIFS....Formula Ammendment
    By 3smees23 in forum Excel General
    Replies: 2
    Last Post: 05-22-2012, 08:53 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