Question

This excel code works but I need to only count the numbers <1205 after G29 >0. This code goes back and counts all of of them. I want to do this without having to create a macro. Is this possible?

=IF(G29>0,COUNTIF(14:14,"<1205"))

Answer 1

Its possible to count them but you need to specify the correct range.

Let me first tell you why your code is giving the wrong output. This is the general syntax of if statement in excel.

=IF (logical_test, [value_if_true], [value_if_false])

=IF(G29>0,COUNTIF(14:14,"<1205"))

In your code, the value of G29 is checked. Since it is greater than 0, the countif statement is always executed. 14:14 means the whole 14th row is checked for values greater than 1205. So the output consists of count of all the values.

The correct code needs to have the specific range. Lets assume your row consists of 10 values, but you need to start from the 5th value. So the correct code should be:

=COUNTIF(E14:J14,"<1205")

Replace E14 by the cell from which you want to start and J14 by the address of last cell in the row.