Hello again all, I have a spreadsheet which calculates my totals on book sales, one of the columns is eBay fee’s and I’m using the following formula on a separate sheet to tell me, month by month, certain things, one of which is the ebay fee’s
All months return the expected figure until I get to December, which in the example above is the number “12”. Up until this point, all months previous and after December show the expected results, obviously Jan, Feb, Mar, etc show nothing as we haven’t got to those months yet but December (12) is showing a figure which I can’t explain. If I’m right, the above formula basically looks in the column “C” for the “month” then looks in the column “L” for the amount and add’s these amounts up if it finds the month. I do have amounts in “L” after November but no dates entered in column “C” yet for December, so I can’t figure why it’s showing an amount if I don’t yet have December in column “C”.
Can anyone shed any light on this or am I on glue?