I have a slight problem here any input would be appreciated.

Trying to gather a data that has 2 conditions where both of them have to be true.
1st condition Name
2nd conditionam Date

Here is the code of what I haves so far.
=COUNT(IF(Requests!H:H,"<="&DATE(2012,4,31),IF(Req uests!D:D,"Marcus Comins")))

Ironically enough trying to set this up in VBA however need to get the formula to fucntion in the first place.

Thanks in advance

Aram