Hi guys, just wondering if anyone can help me.
I'd like to add up the values in a certain column but only when data in the row conforms to certain criteria.
As an example, if the value in column A can be England, Scotland, Ireland or Wales, the value in column B can be Yes, No or Maybe, and the value in column C can be any number, how would I find the sum of every figure in column C that had Scotland and Yes as the values in it's row.
I hope this is clear and thanks for any help.
Bookmarks