+ Reply to Thread
Results 1 to 10 of 10

Multiple criteria countif or sumproduct

Hybrid View

jmerre Multiple criteria countif or... 09-16-2009, 09:58 AM
NBVC Re: Need some guidance with... 09-16-2009, 10:03 AM
zbor Re: Need some guidance with... 09-16-2009, 10:05 AM
DonkeyOte Re: Need some guidance with... 09-16-2009, 10:13 AM
jmerre Re: Need some guidance with... 09-16-2009, 02:08 PM
DonkeyOte Re: Need some guidance with... 09-16-2009, 02:16 PM
jmerre Re: Need some guidance with... 09-16-2009, 02:43 PM
jmerre Re: Multiple criteria countif... 09-16-2009, 02:50 PM
NBVC Re: Multiple criteria countif... 09-16-2009, 02:47 PM
NBVC Re: Multiple criteria countif... 09-16-2009, 03:09 PM
  1. #1
    Registered User
    Join Date
    09-16-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need some guidance with multiple criteria countif or sumproduct arrray, or combo

    Thanks for the reply! So close now. I am now returning a 0. Everything looks good and I am wondering if the database that generates the data is giving me some kind of formatting that is causing problems. I verified that the numbers are numbers and not text. Think of anything else to double check?

    Thanks again!

    Current line returning 0 Should be returning 5 or more.

    =SUMPRODUCT((('Entire Sites - Offices - Staff'!B5:B99="Northern Oklahoma District")+('Entire Sites - Offices - Staff'!B5:B99="Rocky Mountain District")),--('Entire Sites - Offices - Staff'!G5:G99>0),--('Entire Sites - Offices - Staff'!G5:G99<60))

  2. #2
    Registered User
    Join Date
    09-16-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Multiple criteria countif or sumproduct

    Thanks, it seems to be working now. I copied and pasted the same line into a different cell and it seems to be working just fine. Thanks for all the help. This is a great forum.

+ Reply to Thread

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