IF Formula
=SUM(A2:INDIRECT(ADDRESS(2,MATCH(K2,A1:E1,0),4,1)) )
If you have all months, adjust ranges!
Regards,
Stefi
€˛Lisa€¯ ezt Ć*rta:
I need help with the formula.
A B C D E
1 Jan Feb Mar Apr May
2 10 5 15 7 8
If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2.
Thank you in advance.
|