Thread: SUMIF: How to add some cells and ignore other cells in a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danish Ayub[_2_] Danish Ayub[_2_] is offline
external usenet poster
  
Posts: 2
Default SUMIF: How to add some cells and ignore other cells in a row
B3=1 C3=100 D3=1% E3=100 F3=10% G3=90% H3=99
(it starts from B3 and ends at AM3 i.e 21 cells wide)

from the said range i wish to SUM only the values which are not percentage
values.
SUM from B3 to AM3 ignoring percentage cells.

i used =SUMIF(B3:AL3,"<100%")-1 to add only the cells having value in
Percentage

Reply With QuoteReply With Quote