Month Formula

  • Thread starter Thread starter BenT
  • Start date Start date
B

BenT

Hi All,
I need a formula;
A1:M1 have months, Jan...Feb...March...etc.
A2:M2 have dollar amounts,
I need to fill A3:M3 with these dollar amounts only if it is the current month.
The remainder of the cells from A3:M3 to remain unfilled.
Thanks
Ben
 
On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right

Mike
 
Mike
I thank you very much, it drove me crazy, with your help I done did it,
Thanks, Ben
On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right

Mike
 
Back
Top