Results 1 to 13 of 13

MaxIf using Ranges, #N/A error

Threaded View

shuddle MaxIf using Ranges, #N/A error 10-17-2011, 02:15 PM
NBVC Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:18 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:39 PM
NBVC Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:42 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:44 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:48 PM
NBVC Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:51 PM
Pauleyb Re: MaxIf using Ranges, #N/A... 10-17-2011, 02:53 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-17-2011, 03:53 PM
NBVC Re: MaxIf using Ranges, #N/A... 10-17-2011, 03:59 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-17-2011, 05:09 PM
NBVC Re: MaxIf using Ranges, #N/A... 10-17-2011, 09:18 PM
shuddle Re: MaxIf using Ranges, #N/A... 10-18-2011, 09:41 AM
  1. #1
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    MaxIf using Ranges, #N/A error

    I trying to find the max of the number in range FY12District that have the criteria of 1 in range FY12UnDaysOut using range names. The ranges are the same size. I'm getting a #N/A error.

    1 15
    1 10
    2 5
    1 6
    2 20

    Answer would be 15

    =MAX(IF(FY12District=1,FY12UnDaysOut)) using Ctrl, Shift, Enter
    Last edited by shuddle; 10-18-2011 at 09:41 AM.

Thread Information

Users Browsing this Thread

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

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