COUNT IF with unconditional AND on cell dates
hi Aram,
=SUMPRODUCT(--(Requests!H1:H65535,"<="&DATE(2012,4,31))*(Request s!D1:D65535="Marcus Comins"))
--
isabelle
Le 2012-04-13 11:00, Aramazd a écrit :
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
|