View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robin Krupp Robin Krupp is offline
external usenet poster
 
Posts: 9
Default multiple conditional formatting

=SUMIF($A$8:$A$697,$K725,if(left(I$8:I$697,1)="R", 0,H$8:H$697)