Hello,
Looking to do a COUNTIF statement I believe.
We are looking to find a particular salesperson in this instance Caitlin which is located in column B and then looking for STATE in column E if this is TRUE then total the values found in column H against all the lines found.
The formula...