https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/53665.aspxWed, 14 Apr 2010 08:19:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53665Qazi Anis0https://www.infopathdev.com:443/forums/thread/53665.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53665<p>check attachment</p>https://www.infopathdev.com:443/forums/thread/53162.aspxFri, 26 Mar 2010 20:11:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53162jdubya0https://www.infopathdev.com:443/forums/thread/53162.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53162<p>I&#39;m working on a request form that has multiple status options to select.&nbsp; What i&#39;m trying to do is show how many requests are Open vs. Closed.&nbsp; The problem is there are multiple statuses that are considered Open.&nbsp; I have New, In Process, More Info Needed.&nbsp; I&#39;m trying to work out a formula that will count the number of Open requests that are posted to a Sharepoint site.&nbsp;&nbsp;I have the data connection setup to pull the Status column but can&#39;t figure out how to do the count for each status type and then sum them.&nbsp; Any help is appreciated.&nbsp; Still new to this infopath stuff so please let me know if I need to provide additional details.</p>