Sum Year Totals

[derek davis]

Hello guys can you advise please, I don't understand why I get a "NAME" error. I have attached an example which includes the formula.

I would appreciate your advise.
Thank you

 

[vletm]

derek davis
Your: I don't understand why I get...
You have not 'named' those names : amount, date which You're using in Your formulas?

 

[NARAYANK991]

Hi ,

See your file. Check the named ranges using the Name Manager under Formulas.

See this link for an introduction to Excel named ranges :

https://www.ablebits.com/office-addins-blog/2017/07/11/excel-name-named-range-define-use/

Narayan

 

[derek davis]

Thank you I had forgotten about that process. I am very much appliged for you assistance guys
vletm
&
NARAYANK991