Count If / Match??

[elsaidmi]

Hi everyone,

I'm having trouble making this formula work. Essentially I am trying to Count anything in column A that has a C, for the date that is referenced (C8).
What I am trying to do is..... If Column A equals the letter "C", then count any values under the referenced date that are greater than zero.

I might be way off.



=COUNTIF(INDEX(Sheet1!$A$4:$X$9999,0,MATCH(C$8,Sheet1!$A$1:$X$1,0)),"C")

 

[Aladin Akyurek]

What is "the referenced date" and what do you have in C8?