sumif two conditions moving target

P

Pedro AM

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),U13: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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top