Hi, I would like to make a table to the side of my main worksheet to calculate the following from the main worksheet.

Table headers

Date from | Date to | Total value of quotes | Value of quotes won

Date from and date to will be input and used to mark a range or dates from the main table located in column E
Total value of quotes will use the date range and calculate the total value of quotes raised for that time period. Values are located in column O
Value of quotes won will use the same date range but will only calculate the value of quotes we won, where the word "won" appears in column Q

Thanks for reading