Aug 17 2022 03:24 AM
Hello
I have a list of people & expenses & would like to extract the individual persons total spend into an adjacent cell
image below for example - please help
Aug 17 2022 04:11 AM
=SUMIF($B$3:$B$11,F3,$C$3:$C$11)
=SUMPRODUCT(($B$3:$B$11=F3)*$C$3:$C$11)
You can try SUMPRODUCT or SUMIF.