Hi guys!
I have multiple sheets on a workbook, labelled 1st all the way to 31st.
I'm trying to create a master sheet, and in Cell B5 of each daily sheet, there will be 3 sets of information, Blue, Green or Orange.
I'm trying to sum all sheets, if it's blue in B5 on the daily sheets = 1, if its green in B5 on the daily sheets = 2, if its orange in B5 on the daily sheets = 3.
Whats the formula, to scan all sheets from the 1st to the 31st, and convert the words into the values above and a total sum?
Hope this makes sense?
Bookmarks