Don, Francis, and ryguy7272: thank you all for your quick and useful
responses: SUMPRODUCT and SUM worked perfectly for me. I think I feel silly
for not having got it right before, but I'm there now!