Count a unique figure in two different ranges

[vjharry]

what formula should i use if i have two different ranges and i have to find a unique number in those?

For ex
in one range there are 7 digits out of 4 are 0

in in Second range there are also 7 digits, out of which 3 are 0

so pl let me knwo what formula should I use in that?

[vjharry]

Bumpp...
NO REPLY From ANYONE!!

[:) Sixthsense :)]

Please attach sample workbook with expected output for getting quick and exact solution

[vjharry]

Please find attached file as required

[vjharry]

BUMP... Again No Reply

[:) Sixthsense :)]

What is the expected output? Whether the duplication data will be 0 alone or any other number will also get duplicated? Whether the duplication Number of each range needs to be ignored from count? or duplication number needs to be treated as single count? For entire range or every range?

[vjharry]

Sir, there are four differnet ranges in which two values are there whose value are showing 0 so i need to count those two values ..
i tried in Blue colored cell but not able to find

[vjharry]

Please find reply again sir..
What is the expected output? as per the attachfile it should be 2.
Whether the duplication data will be 0 alone or any other number will also get duplicated? 0 or less than 0 can be also counted
Whether the duplication Number of each range needs to be ignored from count? no
or duplication number needs to be treated as single count? For entire range or every range? no it should not be teated as single count.


Hope I have replied all contents

[acerrhod]

you can not use countifs() for the above calculation but countif() each name range and add them together or change your name range to all and use only 1 countif() say CountIF(ALLRANGE, 0)

[vjharry]

you can not use countifs() for the above calculation but countif() each name range and add them together or change your name range to all and use only 1 countif() say CountIF(ALLRANGE, 0)

I again tried but not coming .. so Could you pl provide me the answer again!!

[acerrhod]

i attached the file

[vjharry]

i attached the file

Thanks, BUT
suppose if data are on multiple sheets then how it will work and also Could you pl let me now Why my Function isnt working?

[acerrhod]

CountIFS() - your formula use is for more criteria within the range but not for multi name range, you are counting the jim with 0 values then still you counting for simond with 0 values but are different name range.

[vjharry]

CountIFS() - your formula use is for more criteria within the range but not for multi name range, you are counting the jim with 0 values then still you counting for simond with 0 values but are different name range.

It is ok but how will I use this formula when data is on Multiple sheets!!... Then I dont think that ALL can be applied thre!!
Also can it be done through IF Function?