I want to check the value of one column (A) and then depending on the
outcome add the value in the same row but column B to a total. Can I do this
in a single cell formula or do I have to have an extra column that does the
logic test and then a cell to do the totalling?