If Statement to Indicate Leave

  • Hi All,


    I really need help on something, i am using excel 2010, i have a table which is getting info from other sheet, the formula i'm using is sumifs, because i need the cell to show the amount of calls taken by each agent on specific day, this is fine, but sometimes the agent is in holiday or OFF, when i enter off for the agent on specific date, it does not show off for that agent on the table, now please if any of you know what can i add to make the cell show OFF on the table, do i need to put something in the formula or do i need to use conditional format by using formula. i really don't know, this is killing me these days.

  • Re: If Statement to Indicate Leave


    it would good to see a sample book, but put into a direction you can use the below if statement:


    =IF(SUMIF(A:A,B2,C:C)>0,SUMIF(A:A,B2,C:C),"OFF")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!