D

#### diepvic

I have a table as below

YTD YTD YTD

Name Jan Feb Mar Apr May

A 23 34 35 2 3

B 2 12 111 3 12

C 142 11 45 23 33

Then I would like to set up a formula which can lookup the Name in the table

above and then sum all the month marked "YTD".

E.g: I type "B" in Cell A6. Then in cell B6 the formula will calculate total

revenue that B earns from Jan to Mar (which are marked "YTD").

Pls advise what the formula should be.

Thanks alot.