![]() |
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 |
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