ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What fomular to use (https://www.excelbanter.com/excel-discussion-misc-queries/83075-what-fomular-use.html)

Orelma

What fomular to use
 
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

What fomular to use
 
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


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com