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