Excel help needed please. - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel help needed please.

generaloneill Avatar
6y, 8m agoPosted 6 years, 8 months ago
I have to find the formula for the fields in B2 and B5 to add up and place the resulting sum in B32.

This may be easy but im just not seing it, anyone know how?
generaloneill Avatar
6y, 8m agoPosted 6 years, 8 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
1 Like #1
Enter this into B32: =SUM(B2+B5)

.. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)
#2
oldmanhouse
Enter this into B32: =SUM(B2+B5)

.. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)


What he said...
#3
oldmanhouse
Enter this into B32: =SUM(B2+B5)

.. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)


Thanks worked a treat and learned something in the process. repped.
#4
Technically you don't need to put SUM or the ();

It will work just as fine with =B2+B5 typed into cell B32

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!