Finding the sum of a group of cells divided by location and sector

**Steve_123** · 04-30-2012, 06:41 AM

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

**Fotis1991** · 04-30-2012, 06:53 AM

Hi Steve and welcome to the forum.

What you mean, "it's not right"?

Your formula, works for me!

**Steve_123** · 04-30-2012, 07:26 AM

Hi Fotis

Thanks for coming back to me. When I put the formula into my spreadsheet it comes back with a #VALUE! error message. Any idea what this could be for?

Cheers

Steve

**Fotis1991** · 04-30-2012, 07:38 AM

Steve. I say again. It's works for me.

Take a look to the example.

If you still, have problem, then pls, upload a small sample workbook.

**Steve_123** · 04-30-2012, 07:48 AM

Hi Fotis

Thanks for this. It now seems to have sorted itself out although I'm not sure how or why! Really appreciate your help, thank you very much.

Steve