countif compatibility 2007 and earlier versions

  • Thread starter Aaron Hodson \(Coversure\)
  • Start date
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
 
S

Shane Devenshire

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))
 
S

Shane Devenshire

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))
 

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

Similar Threads

Difficulty with compatibility mode and Track Changes 2
sumproduct and countif in one formula 2
SUMPRODUCT in earlier verions 5
Runtime error 1004: Select method of worksheet class failed 3
SUMPRODUCT COUNTIF Problem 7
Using the Question Mark With COUNTIF 8
Word 2007 and earlier versions 3
Countif and Sumif functions not working in Excel 2007 3

Top