counting in a range

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

hi
i am getting lost here

i have a range of dates in column A (A1 : A10)
i have a quantity in columm B (B1: B10)

what i want to do is check the date is a valid date ie (a day in january)
if it is count the number in the quantity column

A B
1-1-04 2
10-1-04 2
2-2-04 2


total 4

can you help please

thanks



kevin
 
=SUMPRODUCT(--(TEXT($A$1:$A$10,"mmm-yyyy")=TEXT(E1,"mmm-yyyy")),$B$1:$B$10)

where E1 houses a January date, preferably 1/1/04 (format: m/d/yy).
 
That's not an alternative, rather something different, for it would pick out
any January from any year.
 
thanks works a treat
Aladin Akyurek said:
=SUMPRODUCT(--(TEXT($A$1:$A$10,"mmm-yyyy")=TEXT(E1,"mmm-yyyy")),$B$1:$B$10)

where E1 houses a January date, preferably 1/1/04 (format: m/d/yy).
Click to expand...
 
Back
Top