[firstkyne]

I can't find a question exactly like mine, suprisingly. It is this:
I cannot get the following to work:

COUNT(IF('data 2007-2008'!B:B,"=Advert",IF('data 2007-2008'!A:A,"=May",1,0,0),0))

so the end result of all instances of 'Advert' in column B:B are counted if they occur in 'May' as shown along the row in A:A.

And if I want to do a similar thing where I sum the value of all the Adverts in May...

I can't believe how hard Excel makes this! Please help!

Note that the sum is to be in a cell which is on a seperate page from the data. Also, the data is selected from a dropdown box. I wonder if this is why my various attempts don't work?

Finally, I should add that -for long, boring reasons, I would like to avoid using a pivot table.