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?

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?