I'm trying to create a GDocs spreadsheet to collate data from a survey. I'm fairly new to the advanced features of GDocs/Excel but here's what I'd like to achieve. I've tried Googling but it's a tough thing to search.
I currently have a COUNTIF formula that looks like this:
COUNTIF( 'Survey Data'!F2:F200; "Divisional Exec" )
This works fine. But I would like to refine that. So I want to count the number of times a string appears when
COLUMN A = 'ACT' and when
COLUMN F = 'Divisional Exec' in the same row.
Is this possible to do in Google Spreadsheets? If so how do I do it?
I have tried Multiple Conditions on a CountIF? but can't seem to get it to work for me.