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.
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.
Attachments
Last edited: