Hi guys
I need to use the if function or maybe there is an easier way, the information I have is like below
A1. B1. C1. D1. E1. F1. G1
50. Yes. 100. 60. Yes
What I need to put in is if B1 says yes then add A1 and if D1 says yes then add C1 or if it blank add 0
And so on, in G1 I need the total for A1, C1, E1, it does go on a lot more but if I can get the correct function for the above it would be fab.
Any suggestions it's doing my head in
Thanks
Last edited by Fiona Clarke; 07-22-2017 at 08:45 AM. Reason: As requested by admin
Try
=SUM(IF($B1:$Z1="yes",$A1:$Y1))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
@Ali, OP has (had) changed title so I replied.
Worked a treat thanks so much , so simple when you know how
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks