Forum Discussion
how to use sum product count unique value with more condition? Many thx in advance!
Hi, all I have a question to ask for a formula I plan to use in excel: this is my situation: 1. in E column, we have 10k rows of different school name normally end with school, high school or mid...
Deleted
New formula:
=SUM(--(FREQUENCY(IF((UPPER(LEFT(A2:A8872,3))<>"USD")*(UPPER(A2:A8872)<>"UNKNOWN")*(UPPER(A2:A8872)<>"MULTIPLE")*(UPPER(A2:A8872)<>"NON-SEDGEWICK COUNTY-NOT SPECIFIED"),MATCH(A2:A8872,A2:A8872,0)),ROW(A2:A8872)-ROW(A2)+1)>0))
thank you sir, i tried your method but showing:
did I do sth wrong?
so the school list name ranges from ** elementary, to XX High school or && academy;
when I use sumproduct I want to remove the unique value of those condition:
1. name starting with USD
2. name = multiple
3. name = unknown
Did you check my attached file? You formula looks fine. Can you attach a sample file which you getting wrong result? Also what is your excel version? In case of Microsoft-365 you can try second formula.
The user deleted their account...