I need a formula for a Golf Scorecard

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 <at>yahoo<dot>com
----
"Timmy" <Timmy@discussions.microsoft.com> wrote in message
news:86AC9940-DD68-4E28-A342-8EB2B1B77D97@microsoft.com...
> 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

Of course!!!

Thanks Max
Bill K

"Max" <demechanik@yahoo.com> wrote in message
news:ee$$e4fiFHA.3328@TK2MSFTNGP10.phx.gbl...
> 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 <at>yahoo<dot>com
> ----
> "Timmy" <Timmy@discussions.microsoft.com> wrote in message
> news:86AC9940-DD68-4E28-A342-8EB2B1B77D97@microsoft.com...
>> 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
>
>

You're welcome, Bill !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Bill Kuunders" <bill.kuunders@xtra.co.nz> wrote in message
news:O2y6$mmiFHA.320@TK2MSFTNGP09.phx.gbl...
> Of course!!!
>
> Thanks Max
> Bill K

Sorry for the slow response guys....Thanks alot for you help!!! That was it
(Max's formula).Now all I got to do is win!!!

"Max" wrote:

> You're welcome, Bill !
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Bill Kuunders" <bill.kuunders@xtra.co.nz> wrote in message
> news:O2y6$mmiFHA.320@TK2MSFTNGP09.phx.gbl...
> > Of course!!!
> >
> > Thanks Max
> > Bill K
>
>
>

You're welcome, Timmy !
Thanks for posting back ..
Good luck with your winnings <g> !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Timmy" <Timmy@discussions.microsoft.com> wrote in message
news:95091A12-AC3C-4BEE-B887-C3118E143C26@microsoft.com...
> Sorry for the slow response guys....Thanks alot for you help!!!
> That was it (Max's formula).Now all I got to do is win!!!