question to total service types based on certain selections

[steve400243]

On my spreadsheet Column “R” on ‘Spot Quotes Tab’, has a dropdown with several Service types that a user can select, as shown below. Column “X” has a yes or no dropdown, If yes is selected I need the formula to count up, by service type, on another tab “New Customer Report”. So If 'AE' is selected in Column R, on Spot Quotes, and 'YES' in column X, is also Selected it would count 1 next to AE in cell D25 on the “New Customer Report” . If “NO” is selected it would not count it. Make sense? Thanks for all help

AE (D25) 1

OE FCL
OE LCL
AI
OI FCL
OI LCL
INLAND
SURFACE
ORIGIN/DEST
F/F

 

[steve400243]

If anyone is looking at this, I was able to figure it out by adding in a week number column, with the below code - No need to keep working on it. Thank you.

=COUNTIFS('Spot Quotes'!$A:$A,WeekNo,'Spot Quotes'!X:X,"YES",'Spot Quotes'!R:R,"AE")