Replacing Values

[CorvusReed]

I've got an equation going and everything is shiny, only hitch is that instead of it returning a "False" I just need it to return a black cell. Already tried an IfError statement with no luck.

My equation so far-
=IFERROR(IF(($E5<>$E4),IF($E5<>"",$Y5,($Y5+$Y4))),"")

Variables explained:
Column E - manager name
Column Y - numerical value (either 0 or 1)

So basically, I need the equation to keep a running tally of the values in column Y for each manager (column E). How do I get that "false" to disappear?

[ben_hensel]

like this?

=IFERROR(IF(($E5<>$E4),IF($E5<>"",$Y5,($Y5+$Y4)),""),"")

well, technically that returns an empty text string rather than a blank cell.

[CorvusReed]

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?

[ben_hensel]

Try this in Z5 (and pull down) instead:

=IF(Y5=0, "", COUNTIFS(E$5:E5, E5, Y$5:Y5, "="&1))

That do what you want?

[CorvusReed]

It does, indeed! Brilliant! Thank you very much for the assist!