2010 spreadsheet doesn't work in 2003

[dragonlor20]

So I finally got my sheet working, I open it up at work and... nothing! Something isn't working in 2003... Can anyone help me figure out what I need to change to make this work in 2003?

[pike]

Hi dragonlor20

the countifs
will have to be

=COUNTIF(..........)+COUNTIF(..........)

Or

=SUMPRODUCT(--(............),--(............))

[royUK]

When you save the 2010 workbook to an earlier version the Compatibility Checker should alert you of possible problems

[dragonlor20]

When you save the 2010 workbook to an earlier version the Compatibility Checker should alert you of possible problems

The compatibility checker seems to cry wolf a lot in my opinion...

[dragonlor20]

Hi dragonlor20

the countifs
will have to be

=COUNTIF(..........)+COUNTIF(..........)

Or

=SUMPRODUCT(--(............),--(............))

This part

Please Login or Register  to view this content.

did not return the same result as the CountIFs function... The result was off by 140.

I really think it is something in the macro that is attached to the button...

Please Login or Register  to view this content.

What do you think?

[martindwilson]

=SUMPRODUCT(--(E1:E1000="REV"),--(F1:F1000="√")) gives same result as
COUNTIFS(E:E, "REV",F:F, "√")

[royUK]

The compatibility checker seems to cry wolf a lot in my opinion...

So you ignore & get problems