countifs on earlier version of excel

  • Thread starter Aaron Hodson \(Coversure\)
  • Start date
A

Aaron Hodson \(Coversure\)

Hello,

I have been working on 2007 excel and used the below formula:

=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2)

I have just noticed upon saving that this will not work on earlier versions
of excel.

How do I need to change the formula please to make it compatible?

Thanks

Aaron
 
A

Aaron Hodson \(Coversure\)

Hi Mike,

Thanks for the info, sorry for the delay,,,

Just completed all sheets but have a problem with this function,

I am using 2007, so the coutifs work fine, of course not when i'm viewing in
earlier versions.

I used the suggested coutif function, but, this gives me an incorrect
result,,,

Please advise,,,,

Thanks

Aaron
 
P

Pete_UK

I think you would need:

=SUMPRODUCT((JAN!G1:G1000=B14)*(JAN!B1:B1000=C2))

Note that you can't use full-column references before XL2007 - change
the ranges to suit.

Hope this helps.

Pete
 
A

Aaron Hodson \(Coversure\)

Hi Mike,

Thanks for the info, sorry for the delay,,,

Just completed all sheets but have a problem with this function,

I am using 2007, so the coutifs work fine, of course not when i'm viewing in
earlier versions.

I used the suggested countif function, but, this gives me an incorrect
result,,,

Please advise,,,,

Thanks

Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top