Results 1 to 6 of 6

SUMPRODUCT formula returning #NUM! error message

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    20

    SUMPRODUCT formula returning #NUM! error message

    I'm sorry for being a huge nightmare.

    I have two sheets running within the same workbook:

    All Information

    and

    Data Breakdown


    Now, in "All Information", Column B:B is "Ethnicity" and Column G:G is length of time of wait for interview.

    So, I am wanting to find the number of occurences each ethnicity has waited under 6hrs, over 6hrs and over 12hrs. The timing of interviews are formatted to hh"hrs",mm"mins" so for example 1 hour 23 minutes would read as: "1hr,23mins" (I'm not sure if this makes a difference)

    My first formula I'm trying to do this for under 6hrs is:

    =SUMPRODUCT(('All Information'!G:G="<06hrs,00mins")*('All Information'!B:B="White"))



    I've also tried formatting the cells as [h]:mm using this formula:

    =SUMPRODUCT(('All Information'!G:G="<6:00")*('All Information'!B:B="White"))


    Both present back #NUM

    Can anybody offer guidance where I'm going wrong?

    Thank you.
    Last edited by inneedofhelp1; 11-06-2012 at 09:39 AM. Reason: Change in title

Thread Information

Users Browsing this Thread

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

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