Forum Discussion
COUNTIFS with multiple criteria across two sheets
I wonder if anybody could help me out with this problem please? I would like to create a formula that counts multiple criteria over a number of cell ranges from another sheet. I cannot seem to able ...
You missed closing quotes here
COUNTIFS(INDIRECT("'"&Q4&"'!C920:C2016" ),...
and for other INDIRECT(), plus SUMPRODUCT() is not needed.