I know SUMIF function is (range, criteria, sum_range). I notice the sum_range has to be within the same range like B1:B10, and if I change B1:D10, any value in C and D, are NOT added in the result. Is there a way to add C and D into this sum_range?
Thanks.
Bookmarks