Thread: sumif???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeanette Jeanette is offline
external usenet poster
 
Posts: 24
Default sumif???

If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc)
and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a
formula to sum all numbers in column B whose corresponding color in column A
is "orange"? For example, A1 and A3 are "orange", so the formula delivers
"11", the sum of B1 (3) and B2 (8).

Thanks.
--
Jeanette