I am trying to have a cell count based on the conditions of two other cells
on a different sheet. Lets say my sheet names are Data and Stats, and I need
a cell in my Stats page to only count cells which are on the Data sheet range
C2:C450 and equal to "ACompany" AND cells which are on the Data sheet range
G2:G450 and not null.

I know this should be easy, but I haven't worked in excel in a long time. A
followup to this question would be the same thing except the cells G2:G450
would be between two specified dates.

Many Thanks