Help with formula

kborrell

I'm trying to write a formula for a widget. I want to be able to look at another sheet which has two columns that give me the information I need. I want to be able to count items that exist on one column and the number of times that comes up for another number in another column.

Paul Newcome

Are you able to provide some screenshots for context?

kborrell

I'm not really sure what screen shot would help.

kborrell

This is the formula I've tried and it doesn't work. =COUNTIF(({VVD-037 Subject ID Cohort Tracker Range 1}, 1001), ({VVD-037 Enrollment Range 2}, Active))

Paul Newcome

Your formula has too many parenthesis throughout, and you need to use the COUNTIFS function to accommodate multiple range/criteria sets.

=COUNTIFS({VVD-037 Subject ID Cohort Tracker Range 1}, 1001, {VVD-037 Enrollment Range 2}, Active)

kborrell

Unfortunately, that didn't work either

Paul Newcome

I missed that you didn't have quotes around the text string.

=COUNTIFS({VVD-037 Subject ID Cohort Tracker Range 1}, 1001, {VVD-037 Enrollment Range 2}, "Active")

If that still does not work, it would be helpful to know exactly what you mean by "doesn't work". Is there an error message? If so, which one exactly? If not, how is the output different than expected?