Hello,

I need a little guidance with adding cells that only fall into rows that contain certain information. I know that may sound a little confusing , so let me just jump straight to an example.

In reference to the picture below, I’m looking to have Bob and Joe’s “amounts” automatically totaled in the box to the right hand side, without having to manually sort and select each person. Any help with achieving this is much appreciated! Thank you!

Capture.JPG