I need to count the instances when a number appears in one column when a certain text string appears in a different column, in the same row.
When the range B2:B1063 contains "Crossed Above", I need to count the times the number 3000 appears in D2:D1063.
Tried a multitude of variations, using countif, sum, if, exact, etc, etc. all with no success. My current formula is:
But it is not limiting the count to the rows where "Crossed Above" is appearing in the B column.
Can someone assist me with this?