Formula Problem When Using Results From Another Formula

[ChriseeWissee]

Hi All,

I need a bit of help with a calculating spreadsheet. I can seem to get the formula to work in cell AD9 because it is using the result of another formula in its calculations. I have posted a link to the document below. Can someone help me please?

Chris

https://www.dropbox.com/s/728b358qb0yl7oj/Rooming List - Clean.xlsx?dl=0

 

[AlanY]

can try this instead

=SUMPRODUCT(L8:AA8,L9:AA9)

 

[ChriseeWissee]

Thank you that works perfect

 

[AlanY]

you're welcome