Thread: SUMIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default SUMIF
=SUM(O$51:O$56)-SUMIF(E$51:E$56,"=0148",O$51:O$56)-SUMIF(E$51:E$56,"=0101",O$51:O$56).
--
Gary''s Student - gsnu200796
Reply With QuoteReply With Quote