Results 1 to 5 of 5

average if sumproduct?

Threaded View

excelnovice12345 average if sumproduct? 02-07-2011, 03:34 PM
DonkeyOte Re: average if sumproduct? 02-07-2011, 03:35 PM
excelnovice12345 Re: average if sumproduct? 02-07-2011, 03:42 PM
NBVC Re: average if sumproduct? 02-07-2011, 03:36 PM
NBVC Re: average if sumproduct? 02-07-2011, 03:49 PM
  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    philadelphia
    MS-Off Ver
    Excel 2007
    Posts
    7

    average if sumproduct?

    hi everyone,
    im trying to average age (D:D) for individuals who are male (C:C) and in a certain group (B:B).
    so far i isolated the males of a certain group by typing in
    =SUMPRODUCT((C:C="male")*(B:B="case")) but now i am interested in averaging this isolated population's age.

    i was thinking =AVERAGE(IF((SUMPRODUCT((C:C="male")*(B:B="case")),D:D) but it doesnt seem to work. what am i doing wrong here?
    Last edited by excelnovice12345; 02-07-2011 at 03:54 PM.

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