What fomular to use

[Orelma]

I have a row of services and i put 1 if a service is received, at the end on
the row i want to put a formula that states if any service has been receive
put 1 or a check. So at the end it can add up all the services received.
Please help
--
Orelma
Office Manager

[Dave Peterson]

If you used 1 to indicate that the service is received, you can use:

=sum(b2:x2)

to total up the number of services done.
(change the columns to match your data)

Orelma wrote:
>
> I have a row of services and i put 1 if a service is received, at the end on
> the row i want to put a formula that states if any service has been receive
> put 1 or a check. So at the end it can add up all the services received.
> Please help
> --
> Orelma
> Office Manager

--

Dave Peterson