Sum Distinct Text on multiple sheets

June 19, 2017 at 08:36:42
Specs: Windows 7
I have a follow up question to
https://www.computing.net/answers/o...

Any idea how to do this if your criteria is not YES or NO but rather you want to sum distinct text string from multiple worksheets?

Sheet 1
Dog
Cat
Cat
Bird

Sheet 2
Dog
Fish

the sum would be equal to 4 (Dog, Cat, Bird and Fish)

I believe it would be some formula combination of SUMPRODUCT, COUNTIF and INDIRECT.


See More: Sum Distinct Text on multiple sheets

Reply ↓  Report •
Related Solutions


Ask Question