View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romileyrunner1 Romileyrunner1 is offline
external usenet poster
 
Posts: 73
Default Basic Percentage issue: HELP!!!

Hi, got a problem with the following:
I want to find the percentage of cells that are greater than 24 in a collumn
out of all the cells in the collumn that have an entry (some will be blank) .

Then I want to do the same but only for the cells that satisfy a pervious
requirement from an earlier collumn eg "Female".

SUMPRODUCT((E10:E89="Female")*(GD10:GD8924))/SUMPRODUCT((E10:E89="Female")*(GD10:GD890))

Would this work???
Thanks
RR1