Thread: "if" function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
raf
 
Posts: n/a
Default "if" function

I've got three columns
Column A Column B Column C
L 5-Jan-2006 5,000
M 7-Jan-2006 100
L 1-Feb-2006 10,000
U 24-Mar-2006 10

Alpha code "L" 15,000 Function '=SUMIF(A2:A5,"L".C2:C5)'
Alpha Code "L" in Jan (??? Function)

How do I write the formula to get the alpha code L total for January?