Hi there

Can anyone please help?! I'm trying to find the total number from the cells in Column G split down by Division (Column C), Sector (Column D) and Location (Column F). This is the formula I'm trying to use at the moment but it's not right...

=SUMPRODUCT((C2:C238="PERMANENT")*(D2:D238="ENGINEERING")*(F2:F238="UK")*(G2:G238))

Any help much appreciated!

Thanks

Steve