Sure, I can help you with that!
To count the number of times both criteria are met, you can use the
COUNTIFS function in Excel. Here's how:
- Select the cell where you want to display the result.
- Type the following formula: =COUNTIFS(range1, criteria1, range2, criteria2)
- Replace "range1" with the range of cells that contains the values you want to check for "737". Replace "criteria1" with "737" (without quotes).
- Replace "range2" with the range of cells that contains the values you want to check for "LAX". Replace "criteria2" with "LAX" (without quotes).
- Press Enter to see the result.
For example, if your data is in columns A and B, and you want to count the number of times "737" appears in column A and "LAX" appears in column B, the formula would be:
=COUNTIFS(A:A, "737", B:B, "LAX")
This will give you the count of all the rows where both criteria are met.