View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cbanks
 
Posts: n/a
Default SUMIF Complicated.

I have numbers 1-10 in Column A.. I am only interested in the number 2..
Column b has dates.. 1/24/2006 is the day i also want..
if column a is 2, and b is 01/24/06, then i need it to sum whats it is in
row U for that cell.

here is what i have.. i basically need 2 criterias.. and im stumped.

=SUMIF($A$2:$A$64000,2,$U$2:$U$64000)

help please.