Results 1 to 4 of 4

SUMPRODUCT and MAX doesnt find me a negative value

Threaded View

Sarangsood SUMPRODUCT and MAX doesnt... 11-24-2011, 09:12 AM
NBVC Re: SUMPRODUCT and MAX doesnt... 11-24-2011, 09:20 AM
tom1977 Re: SUMPRODUCT and MAX doesnt... 11-24-2011, 09:20 AM
Sarangsood Re: SUMPRODUCT and MAX doesnt... 11-24-2011, 10:42 AM
  1. #1
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    SUMPRODUCT and MAX doesnt find me a negative value

    i want to find the highest number in a range which , but it should be less than 10.
    i am using the formula : =SUMPRODUCT(MAX((B1:B18<10)*B1:B18))

    But the problem is the highest value in the range below 10 is -4 , which this formula is unable to find. It returns the value as 0.

    thanks
    Last edited by Sarangsood; 11-24-2011 at 10:42 AM.

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