aleksandrae
New Member
- Joined
- Sep 28, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi,
I have formula as below ad its works. However I need to know in advance how many sheets I will have and then add it into formula by hand. Is there any solution to automate it? I've tried indirect formula but it does works (maybe I use it in wrong way).
=SUM(IFNA(COUNTIFS(INDEX('1*'!$C$2:$E$125,MATCH($A10,'1*'!$A$2:$A$125,0),MATCH(D$1,'1*'!$C$1:$E$1,0)),"p"),0),IFNA(COUNTIFS(INDEX('2*'!$C$2:$E$125,MATCH($A10,'2*'!$A$2:$A$125,0),MATCH(D$1,'2*'!$C$1:$E$1,0)),"p"),0),IFNA(COUNTIFS(INDEX('3*'!$C$2:$E$125,MATCH($A10,'3*'!$A$2:$A$125,0),MATCH(D$1,'3*'!$C$1:$E$1,0)),"p"),0))
Ps. I paste only the formula and jpg because I have a problem with copy/paste mini-sheet (you already try to help me)
thanks in advance,
Aleksandra
I have formula as below ad its works. However I need to know in advance how many sheets I will have and then add it into formula by hand. Is there any solution to automate it? I've tried indirect formula but it does works (maybe I use it in wrong way).
=SUM(IFNA(COUNTIFS(INDEX('1*'!$C$2:$E$125,MATCH($A10,'1*'!$A$2:$A$125,0),MATCH(D$1,'1*'!$C$1:$E$1,0)),"p"),0),IFNA(COUNTIFS(INDEX('2*'!$C$2:$E$125,MATCH($A10,'2*'!$A$2:$A$125,0),MATCH(D$1,'2*'!$C$1:$E$1,0)),"p"),0),IFNA(COUNTIFS(INDEX('3*'!$C$2:$E$125,MATCH($A10,'3*'!$A$2:$A$125,0),MATCH(D$1,'3*'!$C$1:$E$1,0)),"p"),0))
Ps. I paste only the formula and jpg because I have a problem with copy/paste mini-sheet (you already try to help me)
thanks in advance,
Aleksandra