Thread: I need help with a text and quantity summary report.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
triffidbook triffidbook is offline
external usenet poster
  
Posts: 18
Default I need help with a text and quantity summary report.
Thats done it :) Excellent thank you very much.

"daddylonglegs" wrote:

Looks like you need SUMIF

=SUMIF(A1:A500,"productname",B1:B500)


Reply With QuoteReply With Quote