Forum Discussion
SUMIF question
Hi! I use =SUMIF(B:B;I1;D:D) =SUMIF(B:B;I2;D:D) =SUMIF(B:B;I3;D:D) etc, but would like to use =SUMIF(B:B;I:I;D:D) but it doesn't work. Is there a way to solve it? Thank you in advance!...
I wouldn't use entire columns, it slows down recalculation.
Let's say the criteria range is B2:B1000 and the sum range is D2:D1000.
The values to match are in I2:I15.
Select J2:J15.
Enter the following formula and confirm it with Ctrl+Shift+Enter to make it an array formula:
=SUMIF(B2:B1000,I2:I15,D2:D1000)
(Use ; instead of , if you use comma as decimal separator)