Average and Sum Help

toonyb

New Member
Hi everyone, Im new to excel and have gotten lots of help from reading through many posts, so first thank you to everyone who takes the time to post and of course answer these questions.

I need help with the below if anyone can help, and so you are aware I am using Excel 2003 so I cannot use Averageif or IFS.

I want to calculate an average value based on the value before it and more this across 12 months. this is easy enough using the below example using the last Cell A12.

=AVERAGE(A1:A11) however I want excel to automatically ignore the average calculation if another cell on a different page has a figure in it and use this figure instead of the average figure.

I hope that's easy enough to understand. I am using this to calculate a cash flow projection in case this makes it easier for anyone to understand.

Can anyone help and thank you in advance.

Tony

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
=if(sheet2!\$a\$99=999, 999, average(...............))

=if(sheet2!\$a\$99=999, 999, average(...............))

Thank you very much Oldbrewer

I have to play around a bit to get it work and it seems to like:

=IF('Yearly Summary'!F9>=1,'Yearly Summary'!F9,IF('Yearly Summary'!F9=0,AVERAGE(D3:E3)))

So far testing appears to be accurate, Ill finish off all my tests before I mark this as solved.

thanks

Replies
2
Views
165
Replies
1
Views
191
Replies
3
Views
1K
Replies
19
Views
873
Replies
3
Views
477

1,196,028
Messages
6,012,956
Members
441,740
Latest member
IammeResources

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back