Excel formula required that helps counting multiple columns having any specified value

Hello everyone,

I have multiple columns in excel that contains values like this

A B C D E F G H
Trx Vol Trx Vol Trx Vol Trx Count Vol Count
1 2200 1 4000 1 3500
1 2503 1 2900 1 2499
1 3000 1 3000 1 2700



Now at the last columns G & H i want to get the result that how many column of title "Trx" are having values greater than or equal to 1 and how many columns of title "Vol" are having values greater than 2500 respectively.....

Regards,

Afzal

Try

Formula:

Please Login or Register  to view this content.