View Single Post
  #1   Report Post  
Mats W.
 
Posts: n/a
Default Sumif - double columns

I need to find a way to summarize the values from column C if the Column A
and B is the same as the criteria.

Example:

Col A ColB ColC
A C 10
B C 12
B B 15

The function whould then look for tehe criteria (B) in both column A and B
and give the result of 15. (Unfortnately the SumIf(A1:A10;"B";C1:C10) only
works for one "search" column). Grateful for any comments that can help me
with this issue! Thanks!
--
Mats W.