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
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
Condition d=12 same in both the requirements.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
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:
Formula:
=IF($D4=12,SUM($R4:$S4)/12,IF(AND(F$3>=12-$D4-1,SUMIF($E$3:E$3,">0",$E4:E4)<$R4),SUM($R4:$S4)/$D4,0))
Good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks