View Single Post
  #1   Report Post  
Bob
 
Posts: n/a
Default for SUMIF function, how do I use 2 sets of range & criteria

I am trying to sum one column set if it meets the conditions of two other
column sets
Example
Site Level Work Effort
A 1 .2
A 2 .1
A 2 .15
B 2 .6
C 3 .1
In this example I want to sum Work effort for all Level 2s that reside in
Site A. Basically it requires two sets of Range/Criteria in the Sum if
function. Is this possible? I am have trouble trying to include it in the
formula