# Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

1. ## Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

Hello all

I attach a workbook. One sheet has my invitees in it (CURRENT RECORDS), the sheet called CEREMONIES contains SUMPRODUCT formulae to show how many adults and how many children have been invited to a ceremony. I have used SUMPRODUCT to calculate these. If I want to show how many have accepted and how many children are attending I can use SUMIFS and it works. My problem is that at work I have to use Excel 2003 (aaargh) which does not include SUMIFS.

I could use pivot tables in Excel 2003 but have a feeling that my colleagues wont like them at all.

Can anyone help me with the 3+ criteria? I tried some code from another site but it didn't work.

Many thanks

2. ## Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

Hi

Not exactly sure where you needed to put this, but I added to the formula in B5. The same method would apply to any others you want to add to...
=SUMPRODUCT((Current_records!L\$2:\$L\$202=\$A\$2)*(Current_records!\$M\$2:\$M\$202=\$B\$2)*(Current_records!\$N\$2:\$N\$202=Ceremonies!\$C\$2)*(Current_records!\$H\$2:\$H\$202))

3. ## Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

Happy to help, thanks for the feedback

4. ## Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

My pleasure

There are currently 1 users browsing this thread. (0 members and 1 guests)