Hi DILIPandey,

Thanks for replying...I think that is close, only I will need to duplicate this formula later for the "false" entry as well, and I am not sure how it worked.

I have attached what I working on.

UPDATE: I can get it to work, but only if I let Excel reformat "True" to TRUE - which I believe is an expression? (sorry for my lack of knowledge). Unfortunately, I can't let it do that, as I am going to be creating the final report in a separate spreadsheet and I don't want the end user of this report to have to reformat any of that data (they may or may not have rights to do so).

Again, super grateful for any help!

ExcelCountIfHelp.xlsx