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 will always be kept on Sheet "Total" in Cell "A4"
Example below:
<tbody>
</tbody>
Probably an easy one for you guru's appreciate the help
Luke
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 will always be kept on Sheet "Total" in Cell "A4"
Example below:
Date | Sales Person | Quote Number | Cust name | State | Post code | Shed Size | Quote Value |
1 | Caitlin | NSW | $1000 | ||||
1 | Caitlin | QLD | $9999 | ||||
1 | Caitlin | NSW | $2000 | ||||
1 | Caitlin | NSW | $3000 |
<tbody>
</tbody>
Probably an easy one for you guru's appreciate the help
Luke