I have a workbook with different worksheets for each month, and for each month I record costs for different categories of expenditure, with different clients.
My summary sheet contains a table showing a breakdown - for each category - of the total cost, by month, using a formula like this in each cell:
SUMIF(Jan!$B$2:$B$2998,"category",Jan!$G$2:$G$2998)
Now I've gone multi currency and want an extra column in my monthly worksheets showing a currency indicator - $, €, and £ - so that I can have three separate tables on my summary sheet, one for each currency.
I've tried changing the formula to:
IF(Jan!$Q$2:$Q$2998="$",SUMIF(Jan!$B$2:$B$2998,"category",Jan!$G$2:$G$2998),)
... but it doesnt work. That last example still includes £ values. Can someone please tell me where I am going wrong?
Is there a simpler way of doing this that doesnt involve having 3 worksheets per month?
Many thanks.
Bookmarks