Of course!!!

Thanks Max
Bill K

"Max" wrote in message
...
If I've read you correctly, this might work (in a single cell):

Put in say, C1: =SUMPRODUCT(--(B2:B100-A2:A100=2))

Adapt the range to suit ..

And for a cleaner look when cols A and B are cleared, you could switch off
extraneous zeros display in the sheet via:
Click Tools Options View tab Uncheck "Zero values" ok
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Timmy" wrote in message
...
Great!!!!thats it!! Now Can I enter more than one function like this in
the
same formula to keep building my total ....something like:

=IF(B2-A2=2,1,"") + (B3-A3=2,1,"") + ........and so on, so my result of
1
would keep tallying 1+1+1+1 = 4