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

I would like to do a sumif and have logical statement to
filter sum values out.


Example:

A Column B Column
S4 1
S5 2
S2 3
S1 100

Sumif(a 1 to 4, <"s4",<"s5","<"S2", b 1 to 4)
= 100.
How do I are the expression to only add the "S1"?