=SUMPRODUCT(COUNTIF(INDIRECT("'"&sheets&"'!"&rng),criteria))
=SUMPRODUCT(COUNTIF(INDIRECT("'"&sheets&"'!A1:Z10000"),B5))
"'"&sheets&"'!A1:Z10000"
{"'Sheet1'!A1:Z10000";"'Sheet2'!A1:Z10000";"'Sheet3'!A1:Z10000"}
{5;6;5}
Hi, I'm Mr Z-Lib Admin of Z-Lib.click .Thank you so much and I hope you will have an interesting time with Z-Lib.click . Mail: webappninja1@gmail.com - PHONE : +84779313987.
Learn More →
Leave a Comment