Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula using data from 3 separate columns
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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula using data from 3 separate columns
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 "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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloaded CSV Data to Automatically Appear in Separate Columns | Excel Discussion (Misc queries) | |||
Separate data in a column into new columns | Excel Discussion (Misc queries) | |||
Separate data into two columns | Excel Discussion (Misc queries) | |||
swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
swapping data from 2 separate columns | Excel Discussion (Misc queries) |