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.