Excel Help [Solved/Closed]

Report
Posts
5
Registration date
Tuesday July 31, 2012
Status
Member
Last seen
August 1, 2012
-
Posts
5
Registration date
Tuesday July 31, 2012
Status
Member
Last seen
August 1, 2012
-
Hello,



I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " OFF", i need to see the eighth column contain the result 0 or if all the range of columns is blank the result in the eighth column should be "8". Please help me to rectify the problem.

Eg: A1:F1 IS "OFF"(IN ANY COLUMN),"0" IN G1; IF BLANK THE G1 RESULT SHOULD BE "8".
Thanks.

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
suppose data is like this

name mon tue wed thu fri
A off off
B
from A1 to F3
in G2 type this formula
=IF(COUNTIF(B2:F2,"off")>0,0,"")
copy G2 down.
Posts
5
Registration date
Tuesday July 31, 2012
Status
Member
Last seen
August 1, 2012

Hi Venkat,

The answer which you posted is useful and solved my problem.

Thanks & Best Regards,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!