I am no geek when it comes to sheets, most of the stuff I do comes from watching a video on youtube. I have a retail booth at a flea market and I get  my items from various resources, Some items come from estates that I buy, some from garage sales, some from a local auction house etc. I use the cents in the pricing to help identify where the items were purchased. For an estate sale, the price would be, for example, 10.31, so I can look at the daily sales report and immediately identify every item sold ending in .31came from the estate sale. What I’m wanting to do is  list the different sources I use and have sheets track and total each item based up the cents.  So in the Cell that has a heading Estate Sales, create a sum formula with the criteria of searching the sales report looking for every item sold that ended .31 Thanks in advance for the replies.  If this isn’t possible, is there a way to copy and paste selected random cells.  When I highlight multiple cells using the ctrl tab, click copy, then try right clicking paste, the cells don’t stay highlighted and I can’t paste.