Sumifs with variable in formula

[rizmomin]

Hello:

I am successfully using the formula below:

Please Login or Register  to view this content.

I would like to modify the above formula so that $N$ in the above formula becomes varaible depending in the value in cell B14.

Example : if Value in cell B14 = P then above formula needs to change to

Please Login or Register  to view this content.

Please help and let me know if any questions.

Thank you

Riz Momin

[Ace_XL]

Try

=SUMIFS(INDIRECT("AllMonths!$"&B14&"$2:$"&B14&"$1000"),AllMonths!$A$2:$A$1000,Summary!G$1,AllMonths!$B$2:$B$1000,Summary!$A16)

[rizmomin]

Hi Ace_XL:

This works great for me.
Thank you so much for your great help.

Riz Momin