Forum Discussion
I need help with a Sumif formula
Hy everyone
sorry for my English i'll try to do the best to be clear. I write the sumif formula with parameters in italian so that i hope you can understand me better
= somma.se(Intervallo;criteri;int_somma)
I read in the Excel help that if the "intervallo" and the "int_somma" hasn't the same dimentions and range is not a problem, but i am having problem if i change the range of the criteri.
Criteri is in a different sheet than intervallo and int_somma.
The formula gives me different results if i change the position of the criteri parameter.
This behaviour leads me to believe that also the criteria position is important.
Last note I use the entire column as range that is a:a or f:f but also with ranges such as a5:a10 i have a problem.
An example of the formula i am using
Somma.se('riclassifica 2017'!a:a;conti!c::c;'riclassifica 2017'd:d)
Attached a small example. As you can see C is not "seen" and if you change the range of the criteria the formula gives different results.
Any hints please???
Nicolò
A 5
Hi Nicolo,
In general criteria is not the range, that's some value or expression with which you compare each value from first parameter range.
In your case for the criteria conti!c::c formula return the only one value from the same row # where your formula is. For the first row above criteria will be equivalent to conti!c1, next one to conti!c2, etc. Other words, it very depends on position of the formula, you may check in attached file.
Thank you Baklan, i'll try to fix it in some manner, is there a formula which makes the the same work of sumif but indipendent from the position? It will make my work easier
Thanks
Nicolò Zini
They are all independent on the position if proper designed. Which formula to use depends on what you'd like to calculate - from your sample that's unclear.
