Xlookup to sum multiple results

HI everyone


I'm trying to get xlookup to add up the multiple results instead of returning just the first result found.


The formula I'm using is XLOOKUP(TRUE,$C2:$C7,B2:B7,,,) and in this simplified table it's only returning 2, the first completed result. I'd like it to return 12 (row 3 + row 5 + row 7)


Any help is much appreciated. Thanks






iMac 21.5″, macOS 10.15

Posted on Jan 31, 2023 1:41 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Xlookup to sum multiple results

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.