Getting formula error contains error

Dear friends,
I’m getting error in the formula below:

Please Login or Register  to view this content.

If the cell on information sheet $b$1 contains ‘Std. 9 A or Std. 9 B’ then I want the formula for column ‘I’ else a formula for column ‘J’.

Any help will be appreciated.

Thanking you,

Maybe this

=IF(Information!$B$1="","",IF(OR(Information!B$1={"Std. 9 A","Std. 9 B"}),SUM(COUNTIF(I8:I100,">=7"),COUNTIF(I8:I100,"<7"),COUNTIF(J8:J100,">=7"),COUNTIF(J8:J100,"<7")),""))

You had extra "=" in front of the countifs
try:
=IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 B"),(COUNTIF(I8:I100,">=7") + COUNTIF(I8:I100,"<7")),(COUNTIF(J8:J100,">=7") + COUNTIF(J8:J100,"<7"))))

Hi Alkey & Danerida,
Thank you for solution.

Alkey: The formula is doing the sum of column 'I & J' which I don't want. I want the sum of each column as per the condition on infomation sheet.

Danerida: The formula is working fine with correct output of the sum of each column separately as per the condition.

Thank you to both of you for assistance.

Thanking you,