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

#### ckupq

##### New Member
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.

Last edited:

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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!

Last edited:

Replies
3
Views
635
Replies
1
Views
197
Replies
1
Views
651
Replies
2
Views
376
Replies
5
Views
534

1,203,072
Messages
6,053,377
Members
444,659
Latest member
vuphihung

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back