Incrementing if TRUE

[Peter H]

I have a formula which analyses the data each time an
entry is made in a particular cell and returns the value
TRUE or FALSE.

I wish to count the number of times the value TRUE is
returned by imcrementing the value in another cell by 1
each time the data entered equates to TRUE.

I have been trying to achieve this without using a Macro
using the IF command, {If((B4 = TRUE), A4 = A4+1, A4)} but
have drawn a blank on how to make this work.

Can anyone help with what must be a simple and common
enough task please.

Peter

 

[Bob Phillips]

Peter,

If you goto Tools>Options and on the Calculation tab, check the Iteration
box, and set Max Iterations to 1, and this will work.

May be a major problem though. If the last analysis returns a true, and then
the value in another cell changes, then the cell will increment regardless
of the fact that it's real trigger has not happened.This may be a
showstopper for you.