Thread: Formula for searching spreadsheet
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
  
Posts: 256
Default Formula for searching spreadsheet
In article ,
Lozza65 wrote:

... I need to get the values to sum...

Is this what you mean?

=SUMIF(FGU!$A$2:$A$2742,$A5&"*",FGU!$D$2:$D$2742)

Hope this helps!
Reply With QuoteReply With Quote