Countifs extend the range

[sarinky]

Dear everyone,

Can I extend the range in countifs. for example:

=countifs(A1:A10,"Apple", B1:D10,"=1")

What I currently can do is =countifs(A1:A10,"Apple", B1:B10,"=1")

Kind Regards,
Sarin

[:) Sixthsense :)]

Both of your examples are same so not sure what you are trying to do

No need of double quotes and = in your countif

Please Login or Register  to view this content.

[sarinky]

From my example above, I extended the range from B1:B10 to B1:D10 (B1:B10 shows #VALUE!)

Regards,
Sarin

[sarinky]

Sorry for the earlier post. (B1:D10 shows #VALUE!)

[:) Sixthsense :)]

Countif range or Each range of Countifs should be referred to single column alone.

Use sumproduct in this case like this...

Please Login or Register  to view this content.