Annual change column error on financial spreadsheet

[rcp]

Hi,

I'm attempting to do a running spreadsheet of a stock ISA. Everything seems to be working except for my Annual change column, which is the final one.

I want this to show the total change in value over the 12 months, but I don't want anything in the column unless all the requisite rows are filled in. I thought I had done it right but for some reason the values are all different, despite the formula being the same for each. The formula used it:

=IF(COUNT($B$2:$B$13)=12,SUM($F$2:$F$13÷12),"")

Also a note on conditional formatting: in the final version, my annual change will show only one value in the central row, all the others will be green fill and green text (as shown in Quarterly change). This is to allow me to hide rows based on date, which merged cells would not allow me to do.

(Furthermore, for this purpose, I'm using dummy figures)

Thanks

 

[Fluff]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(COUNT($B$2:$B$13)=12,SUM($F$2:$F$13)/12,"")

 

[rcp]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(COUNT($B$2:$B$13)=12,SUM($F$2:$F$13)/12,"")

Ahhhh yes, my parenthesis was in the wrong place. Thank you!

And thanks for your tip about the profile, I have now updated

 

[Fluff]

Glad to help & thanks for the feedback & updating your profile.