I'm after some help if possible, I'm not great with excel, but I've been handed a task at work to put together a workplace checklist. The checklist will be used to score retail stores on their H&S standards.
I've put together the majority of the spread sheet, with two columns 'Y' and 'N', with a further column determining the score gained from questions they've answered positively.
At the bottom of the 'Score' column there's a TOTAL: box, which adds up the points they've gained.
The problem is, I've made the score gained column automatic using the following formula;
=IF(C8="X",2," ")&IF(D8="X",0, " ")
But when I try to get the TOTAL box to add up using the =SUM(F8:13) forumla, It just keeps it at 0.
It worked initially before I added the ampersand (&) - but doesn't when the symbol is added.
any help would but stupidly appreciated.