Counting cells that meet multiple single criteria as variable criteria

I am trying to count how many values meet multiple criteria (as in a standard countifs) but also meet the criteria of being greater than another value in their same row. If possible I would prefer to do this without a helper column (though I know a helper column can easily solve this).

The code that I tried is this:

Please Login or Register  to view this content.

It's that last argument in the range which is tripping me up. The resulting output effectively ignored that last output (using Google Sheets) and the answer was the same as it would have been without it.

Here is an example of what I'm working on:

I've tried searching for other answers and could only find SUMPRODUCT, which does work but does not allow me to also apply the multiple single criteria I need from the COUNTIFS as well.

Any suggestions most appreciated!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

A sumproducts solution should work, although it is hard for me to be sure without a spreadsheet (as Pepe states) on which to test. Try:

Please Login or Register  to view this content.

Also let me ask if any of the data in column C is equal to/less than the corresponding data in column B (if not then that should be why the results don't change).

Try entering this as an array formula:

Please Login or Register  to view this content.

Array formulas are activated with the keystrokes Ctrl + Shift + Enter (not just enter).
Let me know if you have any questions.