Help counting cell data in a culomn based on a date range in an associated culomn??

Help???


The boss wants me to create a report that looks at a date range, a product quantity, and the exsistance of a tracking number for that product and give a total number of products that have been shiped.


Example:

TEST.JPG

Hi cnc74,

How about this...

=SUMIFS($B$25:$B$38,$A$25:$A$38,">="&$F$23,$A$25:$A$38,"<="&$F$24,$C$25:$C$38,"<>")

I've attached a sample, so you can select the date range using drop downs.