If Formula

[mfplayer20]

I am looking to write a formula in columns F-Q, that states If column d =12, then divided the sum of columns r and s across all 12 months or if column d =12 then divided the sum of columns r and s across April through October.

Thanks

[kvsrinivasamurthy]

Condition d=12 same in both the requirements.

[Estevaoba]

Not sure what you are after, but I'll give it a shot:
Assuming you meant D=7 for second example, please try in F4 and drag across and down:

Please Login or Register  to view this content.

Good luck!