count
I tried and I get a "#value". I am trying to count the text in colB or
simply count each cell. Thanks
"Jacob Skaria" wrote:
Try
=SUMPRODUCT((TEXT(A1:A100,"mmyy")=TEXT(C2,"mmyy")) *B1:B100)
If this post helps click Yes
---------------
Jacob Skaria
"Mona" wrote:
I have daily dates (mm/dd/yyyy) in colA and text in colB. In cell C2 I have
03/2008 (mm/yy). I need a formula : count colB when A:A=C2. Thanks! -Mona
|