Hello,
I was wondering if there was a way to use the SUMIF function for a range of criteria instead of using SUMIFS and typing each criteria one by one (criteria range 1, criteria 1, criteria range 2, etc.) theoretically the criteria range for my example would remain the same.
Point being that I want to be easily able to manipulate the criteria range and have it update automatically, instead of going in to the SUMIFS function one by one and removing each one as I will be using this formula for multiple cells throughout my worksheet for different columns, etc.
Please see attached screenshot for example.
The way I have shown it is by using {} and typing in manually, but again if I want to be able to go in and update quickly when I use the same formula cross multiple cells it takes up too much time and I will be using this formula for rows of cells.
Apologies if this is a novice question, I am not an excel wiz by any means.
Thank you
I was wondering if there was a way to use the SUMIF function for a range of criteria instead of using SUMIFS and typing each criteria one by one (criteria range 1, criteria 1, criteria range 2, etc.) theoretically the criteria range for my example would remain the same.
Point being that I want to be easily able to manipulate the criteria range and have it update automatically, instead of going in to the SUMIFS function one by one and removing each one as I will be using this formula for multiple cells throughout my worksheet for different columns, etc.
Please see attached screenshot for example.
The way I have shown it is by using {} and typing in manually, but again if I want to be able to go in and update quickly when I use the same formula cross multiple cells it takes up too much time and I will be using this formula for rows of cells.
Apologies if this is a novice question, I am not an excel wiz by any means.
Thank you