SUMIFS function

PHOTO EMBED

Wed Mar 31 2021 15:12:20 GMT+0000 (Coordinated Universal Time)

Saved by @zscherrer

=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom")
content_copyCOPY

https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b