Formula using data from 3 separate columns

[MSW Intern]

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??

 

[Max]

One way to frame it up is via sumproduct, eg:
=SUMPRODUCT((F2:F10>=--"15 Jul 2009")*(F2:F10<--"15 Aug
2009")*(C2:C10<18),D210)
Adapt to suit the actual extents of the data, and your actual criteria. It's
presumed that dates in col F are real dates recognized by Excel, and that
cols C and D contain real numbers.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Francis]

Hi
Assuming that the criteria dates are from 7/1/2009 to 7/10/2009 in col F
try this
=SUMPRODUCT((F2:F16>=DATE(2009,7,1))*(F2:F16<=DATE(2009,7,10))*(C2:C16<=18))

this will give you the total number for Age is less than or equal to 18

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another