SUMIF - Multiple Conditions

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

Is this waht you need?
( you will have to adapt the range)

Please Login or Register  to view this content.

Thanks arthurbr

Just before you posted had a brainstorm and got the following to work

=SUMPRODUCT(--(Staffing!$C$4:$C204=$C4),--(Staffing!$G$4:$G204<>"vacant"),(Staffing!$N$4:$N204))