Thread: countif and sum if if two condition are satisfied
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default countif and sum if if two condition are satisfied
=SUM(IF((A1:A10="F")*(B1:B100),1,0)) to count the number of cells

=SUM(IF((A1:A10="F")*(B1:B100),B1:B10,0)) to show the sum of such
cells

formulas have to be array-entered = CTRL+SHIFT+ENTER
Reply With QuoteReply With Quote