=COUNTIFS results in #VALUE!

March 5, 2013 at 08:35:53
Specs: Windows 7
=COUNTIFS(PoE,AC38,ELG1R_II,I13) results in #VALUE!: if I remove one or other criteria range/criterion I get an appropriate result. What am I doing wrong?

See More: =COUNTIFS results in #VALUE!

March 5, 2013 at 12:25:51
I have now sorted the problem (with a little help from my son!). Problem centred on the fact that in a COUNTIFS argument all ranges have to be identical. Stands to reason really - and some of mine were different.

Report •

March 5, 2013 at 12:26:53
identical in length, that is - equal start and finish rows.

Report •
Related Solutions

Ask Question