https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/107341.aspxTue, 12 Jul 2016 12:17:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107341bphall740https://www.infopathdev.com:443/forums/thread/107341.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=107341Hilary, As always, you're a genius. Thank you very much for the assistance.https://www.infopathdev.com:443/forums/thread/107335.aspxMon, 11 Jul 2016 23:06:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107335Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/107335.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=107335Interesting! I'm attaching a sample - save it locally, right click and select Design to open in Design mode, then you can preview and see the calculated value change when you fill in cells. I'm just counting non-blank - you could use a field for this and put a default value in it, if you needed to promote this.https://www.infopathdev.com:443/forums/thread/107330.aspxMon, 11 Jul 2016 19:49:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107330bphall740https://www.infopathdev.com:443/forums/thread/107330.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=107330Folks, I'm trying to count the cells that contain a value which are in a repeating table. My repeating table is 7 columns, if someone enters in 3 or 4 values into the first row, I'd like to know how many. Also, if a user fills up one row, add's another and fills in 2 cells in the second row I need to count that. Possible? I tried promoting the fields to my library and adding a calculated column using CountA but I'm getting a count of 7 each time, even though some of the cells are blank.