Automation for ever-changing database

Gieen

The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information.

I used =countif and it worked well for some columns, but I quickly ran into an issue with some columns from the original database were dropdown lists and many cells had multiple criterions, and =countif seemed to be only giving me the statistics for cells that only content the one criterion and none others, meanwhile there were countless other cells that housed that same criterion i was looking for, but because it was grouped with other criterions, it was factored out and now making the data inaccurate. I was wondering how I could get these statistics to display accurately. I appreciate any help 

Paul Newcome

The @cell portion simply tells the CONTAINS function to evaluate the previously established range on a cell by cell basis. In your case, this should be left as is.

Adam Murphy

Not sure what formula you were using but CONTAINS should help with the challenge.

Gieen

Hi, thank you for the suggestion, I think a formula that works for my situation: =COUNTIFS([]:[], CONTAINS("", @cell)), although I am confused by what @cell means, could you help on this?

Paul Newcome

The @cell portion simply tells the CONTAINS function to evaluate the previously established range on a cell by cell basis. In your case, this should be left as is.

Gieen

Thank you so much!

Paul Newcome

Happy to help. 👍️