Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum If Multiple Conditions
Hi Bob
thanks for the correction - don't know what happened there it was a straight copy / paste from excel ! Cheers JulieD "Bob Phillips" wrote in message ... I think Julie means 2005 not 1905 =SUMPRODUCT(--(F2:F784=DATE(2005,1,10)),--(B2:B784=100),E2:E784) -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Grant try =SUMPRODUCT(--(F2:F784=DATE(5,1,10)),--(B2:B784=100),(E2:E784)) Hope this helps Cheers JulieD "Grant" wrote in message ... I need help with my formula. I am trying sum data based on multiple conditions. I used SUMPRODUCT in the past to do this. Column F needs to greater than 1/10/2005 and column B needs to equal 100. If these conditions sum column E. Can this be done? T.I.A. Grant SUMPRODUCT((F2:F784,"="&DATE(2005,1,11)*(B2:B784= 100)*('E2:E784)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
COUNTIF using multiple conditions? | New Users to Excel | |||
Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |