One way to frame it up is via sumproduct, eg:
=SUMPRODUCT((F2:F10=--"15 Jul 2009")*(F2:F10<--"15 Aug
2009")*(C2:C10<18),D2:D10)
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
---
"MSW Intern" wrote:
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??