Hello,
I am currently trying to get this formula to work properly =SUM(COUNTIFS('PC'!$R:$R,{"H","D","L","M","O","P","R","V"},'PC'!$P:$P,{"C1*","C2*","C3*","B1*"}))
It is currently returning a value of 2 which i know is incorrect because the below formula returns a 3 for M (D178& in the below formula targets a cell containing M) so the above formula should return either a 3 or 4 all data considered.
=SUM(COUNTIFS('PC!$N:$N,"*"&$D178&"*",'PC!$P:$P,{"C1*","C2*","C3*","B1
Any ideas on if Using SUM(countifs can be used like this? i would have expected it to either return the correct answer or error.
I can’t attach the actually spread sheet due to data protection and would take too long to edit as i have with the above formula.
Any help will be Greatly Appreciated
Bookmarks