so, do you have a list of Yes and No's? If so, depending on direction..

If going from B2 - IV2, then...

B3 = countif(2:2,"Yes")
B4 = countif(2:2,"No")

would do that...

If you want a running total, then on:

B3, =if(B2="Yes",1,0)
B4 =if(B2="No",1,0)

then, in each subsequent column..

C3, =if(C2="Yes",B3+1,B3)
C4, =if(C2="Yes",B4+1,B4)

"Pickup" wrote:

Hi,

I'm working through a college project using Excel. One of the examples is
to generate a random event (toss of a coin) and then record the number of
outcomes ie how many times heads comes up & how many times tails comes up.

I can't see a way to record the running totals - there's a similar example
given in the notes but i think it might have been done in Lotus 1-2-3

IF(B2="Yes",b3=b3+1, b4=b4+1)

I've tried various permutations of IF, COUNTIF.

Thanks for looking - any suggestions gratefully received.