I have a grid of False's with True's placed randomly in some the cells, with
the first row cells being all merged.
my aim is to count the number of trues in each row minus the merged row
however if I follow the intructions for the use of the formula it comes up
with a #VALUE! error. I am putting the merged cell as the database, the
individual rows as a field and True as the criteria.

how do i get the formula working and/or what other formula do i use?