View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MSW Intern MSW Intern is offline
external usenet poster
 
Posts: 1
Default Formula using data from 3 separate columns

I need to create a formula that pulls data from 3 separate columns. The
formula would answer the following:

If an assessment date is between x and y (column F) AND the victim is under
age 18 (column C), then TOTAL the number of primary victims (column D).

I know it would involve a few nested functions, but just don't know how to
write up the actual formula. Suggestions??