Hi,

You may use the sumif array formula as well (Ctrl+Shift+Enter)

=sum(if((range=7)*(range2<7)*(range3=7),1,0))

Regards,

Ashish Mathur

"Joshcat99" wrote:

I need a formula/function that would work to count the number of records that
have =7 in the 1st column, <7 in the 2nd column and =7 in the 3rd column.