I currently have the following =SUM(IF(Q35="y1","2","0")) which works fine but the problem is I need to do the same with all of the following - If Y2 then +4 If Y3 then +6 If Y4 then +8 And just to make it that little bit more difficult I then need If N1 then -2 and so on. Is this possible or am I living in a dream?
This question generated 19 answers. To proceed to the answers, click here.
This thread is current as of December 12, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel