SUMIFS with multiple criteria

brendaoc

New member
Joined
Jul 8, 2014
Messages
9
Reaction score
0
Points
0
Please help a girl out. I am successful with single criteria sumif function, but can't get the criteria to work on 2 different parameters.

If column $A:$A "books" and column $B:$B= "709 eyewear" then sum Column C

how do I properly write this function?

Thanks!
 
=SUMIFS($C$2:$C$20,$A$2:$A$20,"books",$B$2:$B$20,"709 eyewear")
 
Forgive me if Im stating the obvious, but if your wanting to report the entire columns, leave out the row numbers (as in your op) :)
 
Back
Top