Excel question.
I have a large sheet tracking when I receive certain documents.
In column F i input "received 20120913" when the doc comes through.
I want to sum all the docs I have received, so want to add all the cells that contain the word 'received'. I know SUMIF should get me there but I can't quite get the formula.
Google has not been very helpful. Naughty google.
Excel question.
I have a large sheet tracking when I receive certain documents.
In column F i input "received 20120913" when the doc comes through.
I want to sum all the docs I have received, so want to add all the cells that contain the word 'received'. I know SUMIF should get me there but I can't quite get the formula.
Google has not been very helpful. Naughty google.
Any care to help?