+ Reply to Thread
Results 1 to 3 of 3

SUMPRODUCT formula between worksheets

  1. #1
    Registered User
    Join Date
    09-16-2016
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    1

    SUMPRODUCT formula between worksheets

    Hello Folks

    I'm currently working on something to convince the older generation in my workplace that excel is a good thing and it can help them, however my limited excel knowledge is hindering me. I did plan on attaching the workbook to this thread but it is too large so ill try and explain the issue I am having.

    The workbook currently has two tabs "raw data" and "stats". The raw data tab has information on a whole bunch of reports from the beginning of the year through to the current day, the stats tab has a table that should read from the raw data tab and provide monthly figures.

    One of the stats needs to show how many reports in "2016", in "August", were "hazard observations" and were classed as "first age".

    The raw data tab has a column for the date, another column to say if the report was a "hazard observation" or an "incident" and another column to say if the report was "first age" or "second age". I need a formula that will look for these four criteria on the raw data tab and give me a number on the stats tab. This is the formula I've been playing with but I can't seem to get the "hazard observation" criteria into the formula:-


    =SUMPRODUCT((ISNUMBER(SEARCH("1st - First Age Reports focus on issues with things",'DASOR DATA'!$I$3:$I$12242)))*(MONTH('DASOR DATA'!$AG$3:$AG$12242)=8)*(YEAR('DASOR DATA'!$AG$3:$AG$12242)=2016))

    Whilst this all make perfect sense to me I appreciate there may be lots of unanswered questions which I will try to answer as best I can.

    Thank you in advance for any help you may able to give.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: SUMPRODUCT formula between worksheets

    Please Login or Register  to view this content.
    Not sure what I'm missing.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    09-14-2016
    Location
    New York, USA
    MS-Off Ver
    Mac 2016, Windows 2016
    Posts
    14

    Re: SUMPRODUCT formula between worksheets

    Though to say for sure without seeing the data, but have you tried COUNTIFS function?
    It would probably be easier if you split your date into year and month columns as well.

+ Reply to 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 between date range on two worksheets
    By NotQuiteThere in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2012, 12:13 PM
  2. [SOLVED] Excel 2007 : Sumproduct across multiple Worksheets - #VALUE! Error
    By questionguy in forum Excel General
    Replies: 8
    Last Post: 04-13-2012, 09:06 AM
  3. SUMPRODUCT multiple worksheets
    By SelC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2011, 05:56 AM
  4. How do I use Sumproduct across 3 worksheets
    By spamunch in forum Excel General
    Replies: 16
    Last Post: 01-19-2011, 02:34 PM
  5. SUMPRODUCT across worksheets
    By guerillaexcel in forum Excel General
    Replies: 8
    Last Post: 04-16-2010, 09:09 AM
  6. SumProduct to add different worksheets?
    By HBF in forum Excel General
    Replies: 1
    Last Post: 01-26-2010, 12:28 PM
  7. SUMif or SUMproduct across multiple worksheets?
    By Eric Shamlin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2005, 05:05 AM
  8. [SOLVED] SUMPRODUCT across worksheets
    By Stephen POWELL in forum Excel General
    Replies: 3
    Last Post: 01-24-2005, 11:06 PM

Tags for this Thread

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