Results 1 to 5 of 5

Frozen SUMIFS

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    Nottingham, England
    MS-Off Ver
    2010, 2013
    Posts
    37

    Frozen SUMIFS

    Hi all,

    I've got a series of SUMIFS running on a sheet, giving totals for various elements of a business. However they seem to have stopped working... I've not knowingly altered the formulae. They give some results, but it doesn't seem to count all of the data, meaning that my income total varies by around £30,000. Temporarily, I've got the range set from *column*2:*column*10000, and the data hardly covers 500 cells!

    Weekly figures for (contained on the "stats" sheet):
    Weekly Exclusive rafts (Column C)
    Weekly Individual Rafts (Column D)
    Weekly Income (Column G)
    Monthly Exclusive Rafts (Column M)
    Monthly Individual Rafts (Column N)

    currently do not work. There's various other formulae that rely on these cells, so there's a domino effect going on.


    Any corrections/advice always welcomed!
    Workbook attached

    WWM
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Greetings from the frozen north.
    By RodyMcAmp in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-16-2014, 08:36 PM
  2. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  3. Frozen worksheet...help!
    By tarmon in forum Excel General
    Replies: 3
    Last Post: 08-23-2010, 05:38 AM
  4. Frozen sheet
    By Forexyto in forum Excel General
    Replies: 6
    Last Post: 05-19-2010, 01:53 PM
  5. Frozen Workbook
    By LS Flowers in forum Excel General
    Replies: 2
    Last Post: 01-05-2010, 10:05 AM
  6. Frozen panes won't stay frozen
    By Irshlas in forum Excel General
    Replies: 0
    Last Post: 03-12-2009, 03:15 PM
  7. how can i frozen more than row ?
    By HOSAMNOOR in forum Excel General
    Replies: 4
    Last Post: 11-18-2007, 07:03 AM
  8. [SOLVED] Frozen is cell
    By Stac at Chase in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 03:05 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