InfoPath Dev

Folks, 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.

Interesting! 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.

Hilary, As always, you're a genius. Thank you very much for the assistance.