Looking for Some Sum(if(Frequency help with multiple parameters.

[ckupq]

So I did some searching to try to figure out how to create this formula before posting.

I found this.
Adding a parameter to the SUM/IF/FREQUENCY formula to narrow - Microsoft Community

and it only got me so far. I can't get the base formula {=SUM(IF(FREQUENCY(A12:A200,A12:A200)>0,1))} to work it comes back with 1 or 0 instead of 99 which {=SUM(1/COUNTIF(A12:A200,A12:A200))} does, probably because its an alphanumeric sequence. I added the array brackets to indicate I did invoke an array(C+S+E) and didn't type in the brackets.

After I get I figure out how to get it working. I need to add one or more of the following parameters.
U12:U200="TRUE"
C12:C200="Meeting"
E12:E200=M1

I've spent a couple hours on this and I'm at a loss. Every time I think I get close, I can't manually verify my work.

Edit: This is being done in Excel 2010. I don't believe I have any add-ons.

 

[Domenic]

Try...

=SUM(IF(FREQUENCY(IF(C12:C200="Meeting",IF(E12:E200=M1,IF(U12:U200="TRUE",IF(LEN(A12:A200)>0,MATCH("~"&A12:A200,A12:A200&"",0))))),ROW(A12:A200)-ROW(A12)+1)>0,1))

...confirmed with CONTROL+SHIFT+ENTER. Note, if Column U contains the logical value TRUE instead of the text string "TRUE", you'll need to remove the quotes. So you would need to replace...

U12:U200="TRUE"

with

U12:U200=TRUE

Hope this helps!