https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/115630.aspxThu, 16 Feb 2017 01:47:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115630Curtis0https://www.infopathdev.com:443/forums/thread/115630.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115630<p>I have a Regional Sales&nbsp;Report, with&nbsp;Column A&nbsp;(Name of Product - text field),&nbsp;and Colum B (Sale Status - text field). I, also,&nbsp;have&nbsp;a Regional Summary Report with&nbsp;Column C (Sale Disposition)</p><p>I am trying to write a formula that determines whether&nbsp;Regional Sales Report Column A is &#39;ACME&quot;; If yes,&nbsp;then check Regional Sales Report Column B (&#39;ACME lines), for &#39;Sold&#39;; Count number of&nbsp;&#39;Sold&#39; lines;&nbsp;Auto-populate sum&nbsp;sold in Regional Summary&nbsp;Report Column C, on the line that represents regiona sales for &#39;ACME&#39;.</p><p>&nbsp;&nbsp;</p>