What formula, horizontal and vertical

Hi,

This has stumpped me,

I have a sheet that has names in column A i also have dates from column G - AJ on a single line, what i want to do is do a sumproduct type of thing that will read sideways and find today() then look down column A and find the name then look from columns B - AJ with the value that meets both the critiria, can this be done?

Hi,
Is it possible that more than one value meets both criteria?
Dates are in G-AJ and the values to find in B-AJ?

cant seem to get that work, i have attached a snippet of the worksheet so you can look at.

Thanks for the reply but no it didnt work, it still comes up with the answer of zero even though i put a value in the cell its looking for, for todays date, i am looking and it all looks correct, pehaps you could place it into the workbook for me?

Thanks for your help so far.

Thanks

DJ

Its ok now i changed your formula a bit and now it works.

Please Login or Register  to view this content.

Thanks for your help

DJ