FORMULA HELP

Copper Contributor

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

Paul250410_0-1660731773610.jpeg

 

1 Reply

@Paul250410 

=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.

sumif.JPG