Results 1 to 12 of 12

(SOLVED) Not reading SUMIF formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2022
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2016
    Posts
    6

    (SOLVED) Not reading SUMIF formula

    I have created a spreadsheet where I can add multiple invoices for several states on one tab and they populate on each individual state tab and add up together. I have used this formula {=SUM(IF(Invoices!A1:$A$1009=$A$11,Invoices!D$1:D$1009,""))} but it is not populating the results on each page. The lookup values on each tab are unique by listing the month and state (example: January - WA or January - TX). This is what I list in the A column on the Invoices Tab. My thought is that the spreadsheet is trying to calculate too many cells, since there are 30+ state pages and several different products? Any advice on how to get this to work?
    Last edited by pio479; 11-28-2022 at 04:57 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula reading from two different tabs
    By mrteater in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2022, 05:59 PM
  2. [SOLVED] Usage since last reading formula
    By winnie_the_bish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2018, 09:13 PM
  3. Error in formula reading #VALUE!
    By shanni11 in forum Excel General
    Replies: 3
    Last Post: 09-20-2016, 12:59 PM
  4. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  5. Sumif - reading text keywords from another cell
    By theriel in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-05-2013, 06:13 AM
  6. Help with reading =MIN formula
    By ExcelNUBs in forum Excel General
    Replies: 1
    Last Post: 07-23-2012, 04:07 PM
  7. Pick the last reading and time of that reading
    By thmehr in forum Excel General
    Replies: 10
    Last Post: 03-22-2012, 07:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1