Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif two conditions moving target
Hi All
I am trying to do this using a sum(if formula like this ={SUM(IF(($S$13:$S$21=$D39)*($T$13:$T$21=$G$35),U1 3:U21))} which so far works. However, my last part "U13:U21))" is a moving result depending on a date set in cell G11. i.e. U12 could be =01/01/10 , V12 =02/01/10,w12=03/01/10. I would like it to return he info in 13:21 of the column for the date that I specify in G11. I have tried with ,INDEX(U12:AF21,0,MATCH(G11,U12:AF12,0) in this part but I get N/A and can't see why. Any ideas please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif two conditions moving target
Without looking too far perhaps
G11,U12:AF12, -- Don Guillett Microsoft MVP Excel SalesAid Software "Pedro AM" wrote in message ... Hi All I am trying to do this using a sum(if formula like this ={SUM(IF(($S$13:$S$21=$D39)*($T$13:$T$21=$G$35),U1 3:U21))} which so far works. However, my last part "U13:U21))" is a moving result depending on a date set in cell G11. i.e. U12 could be =01/01/10 , V12 =02/01/10,w12=03/01/10. I would like it to return he info in 13:21 of the column for the date that I specify in G11. I have tried with ,INDEX(U12:AF21,0,MATCH(G11,U12:AF12,0) in this part but I get N/A and can't see why. Any ideas please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with 2 conditions | Excel Worksheet Functions | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
Sumif with n conditions | Excel Worksheet Functions | |||
Sumif with variable target | Excel Discussion (Misc queries) | |||
SUMIF 2 conditions are met??? | Excel Worksheet Functions |