I've been given the task to produce a spreadsheet to track the amount of refunds given to customers for a team of people. The general formatting i can sort out and normally i can work out formulae but i'm stuck today
each agent on the team has their own worksheet to enter the details and that is mapped across to the main sheet for easy viewing.
I have a column "Correct?" with drop down list in each cell with a yes or no option.
I need it to calculate the number of refunds that are correct, so far i have this formula . .. .
=IF(E9="yes","1",0)
which means i've got a hidden column of 1s and 0s but i cannot for the life of me get a total of that column!!!
Any help greatly appreciated
Chunk
Bookmarks