countif compatibility 2007 and earlier versions

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


"Mike H" wrote in message
...
Missed the sheet references

=COUNTIF(Jan!G:G,B14)+COUNTIF(Jan!B:B,C2)

Mike

"Mike H" wrote:

Hi,

=COUNTIF(G:G,B14)+COUNTIF(B:B,C2)

Mike

"Aaron Hodson (Coversure)" wrote:

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

Hi,

The general idea would be

=SUMPRODUCT(--(Jan!G:G=B14),--(Jan!B:B=C2))

However in 2003 you can't reference an entire column with this type of
formula so

=SUMPRODUCT(--(Jan!G1:G100=B14),--(Jan!B1:B100=C2))
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Aaron Hodson (Coversure)" wrote:

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


"Mike H" wrote in message
...
Missed the sheet references

=COUNTIF(Jan!G:G,B14)+COUNTIF(Jan!B:B,C2)

Mike

"Mike H" wrote:

Hi,

=COUNTIF(G:G,B14)+COUNTIF(B:B,C2)

Mike

"Aaron Hodson (Coversure)" wrote:

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

HI

The general idea would be

=SUMPRODUCT(--(Jan!G:G=B14),--(Jan!B:B=C2))

However in 2003 you can't reference an entire column with this type of
formula so

=SUMPRODUCT(--(Jan!G1:G100=B14),--(Jan!B1:B100=C2))
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Aaron Hodson (Coversure)" wrote:

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


"Mike H" wrote in message
...
Missed the sheet references

=COUNTIF(Jan!G:G,B14)+COUNTIF(Jan!B:B,C2)

Mike

"Mike H" wrote:

Hi,

=COUNTIF(G:G,B14)+COUNTIF(B:B,C2)

Mike

"Aaron Hodson (Coversure)" wrote:

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