View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kewlstix Kewlstix is offline
external usenet poster
 
Posts: 1
Default Looking up data.

Howdy. I have been trying to figure out how to do the following;
Example Columns: Date, ItemCode, Desc, Units.
On another sheet, I have Item Code, Date, Units, followed by dates in row 1.
I need to sum all the units that match Item Code, Date. I just don't know
how to do it. I've tried to use and(), but have not received the desired
results.

Can you help me? I really want to be able to do this.