I am using excel 2000
I have a spreadsheet with multiple columns
Column C is Store Name
Column G is Staff Name
Column N is FTE
I need a formula that looks at Column C and for all the stores called A, then looks at Column G and excludes all entries containing "Vacant" and then totals the entries in Column N that correspond
I guess it requires some sort of SUMIF or SUMPRODUCT type formula, but having a mental block and can't get my head around it this morning
Any help gratefully received
Bookmarks