Thread: Sumif
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Sumif
Hi JP,

If your data is located in range A1:A12 :

=SUMPRODUCT(LEFT(A1:A12,1)*(RIGHT(A1:A12,1)="H"))

HTH
Cheers
Carim

Reply With QuoteReply With Quote