How to automatically select specific buyers and add only their purchases in calc

[spider]

In my spreadsheet are a number of columns,including ‘purchase (column b), date (column d), buyer (column e), etc’. I can use the find all function to see everything buyer Bill has purchased and it shows the search results. However, I want to use a formula or a function to actually add the total - purchase (Column b) of all that specific buyer without going to each line and separately adding the purchase. How can I do this? Thank you. I have 2 screenshots to demonstrate the question but don’t know how to attach them?

[Wanderer]

Check the wiki on SUMPRODUCT

https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMPRODUCT

I guess you will need something like
=SUMPRODUCT(B2:B100; E2:E100="Bill")
and for your automatically replace ="Bill" with a reference to a cell, where you input the name (Maybe even use a dropdown with data valitidy for this.)

[Wanderer]

@spider

but don’t know how to attach them?

Try the arrow symbol you can see when editing a comment:

Picture copied from here:

This is the guide - How to use the Ask site?

This is intended to help you use this website. There will be additions to this website as we go along. Bring a positive spirit to your posts, and thank you. Attention, this is not a real question, but a description of how to use this Ask site. [image] also available here : Ask/Guide - How to use the Ask site - The Document Foundation Wiki  Introduction / Basics The community …