I'm working on a request form that has multiple status options to select. What i'm trying to do is show how many requests are Open vs. Closed. The problem is there are multiple statuses that are considered Open. I have New, In Process, More Info Needed. I'm trying to work out a formula that will count the number of Open requests that are posted to a Sharepoint site. I have the data connection setup to pull the Status column but can't figure out how to do the count for each status type and then sum them. Any help is appreciated. Still new to this infopath stuff so please let me know if I need to provide additional details.