Results 1 to 9 of 9

Sumifs reference criteria is text but I want to reference cell

Threaded View

  1. 11-06-2015, 03:18 PM #1
    bbeards2
    bbeards2 is offline
    Registered User
    Join Date
    07-21-2014
    Location
    florida
    MS-Off Ver
    2013
    Posts
    19

    Sumifs reference criteria is text but I want to reference cell

    I am trying to do a sumifs with two criteria but I want the criteria to lookup the text in a cell. I have tried several different things but I cant seem to get the formula to give me anything but 0 unless i type the text in
    Last edited by bbeards2; 11-06-2015 at 04:09 PM. Reason: Solved
    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] I want to change a text reference to a cell reference but im getting #N/A
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-28-2015, 12:12 PM
  2. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  3. [SOLVED] Sumifs using a cell reference
    By rickycr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-23-2014, 07:09 PM
  4. SUMIFS formula with Cell reference
    By sanjeevkumarmc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 09:59 AM
  5. VBA: add SUMIFS formula with cell reference as criteria
    By sepi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2012, 05:57 PM
  6. SUMIFS does not give a value for cell reference
    By inayat in forum Excel General
    Replies: 2
    Last Post: 09-23-2011, 03:02 AM
  7. Text Cell reference and increase the cell reference by step value
    By Supriya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 08:18 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