Thread: addding/omitting "x"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tleehh tleehh is offline
external usenet poster
  
Posts: 21
Default addding/omitting "x"
using this formula, =sumif(a10:a20,{"s1"},b10:b20)
I am trying to add all the values in b10:b20 excluding that is mark "x" in
colume C.
Reply With QuoteReply With Quote