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.
COUNTIF but when multiple conditions are met
google spreadsheets;formulas