I really need help with a spreedsheet, I have five columns of data. I need to add the data in column A if it contains the words Finance Dept, if column A contains the words Finance department and Column D contains the word Glasgow. How many people do I have working in the finance department in Glasgow ? I have tried puting in the following but it does not work sum(if(a2:a500="Finance Department",if(d2:d500="Glasgow",0,1))).
Any help would be appreciated.
contact
us
