like this?
well, technically that returns an empty text string rather than a blank cell.![]()
=IFERROR(IF(($E5<>$E4),IF($E5<>"",$Y5,($Y5+$Y4)),""),"")
like this?
well, technically that returns an empty text string rather than a blank cell.![]()
=IFERROR(IF(($E5<>$E4),IF($E5<>"",$Y5,($Y5+$Y4)),""),"")
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Labor Tracking Log 10.4.xlsx
Sorta, yes. I've attached the workbook with some sample data. Our equation is rocking out in Column Z. I put a couple different manager names in column E so that I could have two separate counts going. So, the count for Ed should be 2 and the count for Same should be 3, given this sample data. Make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks