Overcome Nested IF statements

[Jag Lau]

I have a table as follow on fees and wanted to use the nested IFs to find the accumulated fees depending on which month it is.

A

B

C

D

E

F

G

H

I

J

K

L

M

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Fees

640

500

800

500

650

420

410

550

220

440

160

180

<tbody>
</tbody>

=IF(MONTH(TODAY())=1,B2,IF(MONTH(TODAY())=2,sum(B2:C2),IF(MONTH(TODAY())=3,sum(B2:D2).....

Thats my formula, but because there is a limitation, I cannot test more than 7.

I tried Concatenate formula, but it stopped at the first one.
=CONCATENATE(IF(MONTH(TODAY())=1,B2,""), IF(MONTH(TODAY())=2,sum(B2:C2),""),IF(MONTH(TODAY())=3,sum(B2:D2),"")...

Anyone can help me???

 

[jarjarbingie]

I have a table as follow on fees and wanted to use the nested IFs to find the accumulated fees depending on which month it is.

A

B

C

D

E

F

G

H

I

J

K

L

M

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Fees

640

500

800

500

650

420

410

550

220

440

160

180

<tbody>
</tbody>

=IF(MONTH(TODAY())=1,B2,IF(MONTH(TODAY())=2,sum(B2:C2),IF(MONTH(TODAY())=3,sum(B2:D2).....

Thats my formula, but because there is a limitation, I cannot test more than 7.

I tried Concatenate formula, but it stopped at the first one.
=CONCATENATE(IF(MONTH(TODAY())=1,B2,""), IF(MONTH(TODAY())=2,sum(B2:C2),""),IF(MONTH(TODAY())=3,sum(B2:D2),"")...

Anyone can help me???

=SUM(OFFSET($A$2,0,1,1,MATCH(TEXT(TODAY(),"mmm"),$B$1:$M$1,0)))

 

[MARZIOTULLIO]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

1​

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2​

Fees

640​

500​

800​

500​

650​

420​

410​

550​

220​

440​

160​

180​

3​

4​

5​

4470​

tot fees until august

<tbody>
</tbody>

b5=SUMPRODUCT((MONTH(B1:M1&1)<=MONTH(TODAY()))*(B2:M2))

 

[MARZIOTULLIO]

this work for evrey month that you choose for example april

b5=SUMPRODUCT((MONTH(B1:M1&1)<=MONTH(E1&1))*(B2:M2))