Oct 20 2020 04:12 AM
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!
Nils
Oct 20 2020 04:34 AM
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
You could get a precise solution much faster with a file (w/out sensitive data).
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
It is also helpful to know the operating system and Excel version, as different approaches may be required depending on the version and OS.
At the same time, I would like to draw your attention to the fact that if you are on English excel and use English formulas you would have to have (,) instead of (;) in your formula.
Here is a small example: =SUMIFS($B$7:$B$37,$I$7:$I$37,$D$7:$D$37)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Oct 20 2020 04:41 AM - edited Oct 20 2020 04:42 AM
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)