Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default SUMIF

IF I DO NOT WANT TO SUMIF LABELS S5,S4,S2

a cOL bCOL
s1 100
S2 0
S4 0
S5 25

I WANT MY SUMIF TO EQUAL 100, HOW DO I WRITE THE LOGIC IN
THE SUMIF FUNCTION?