Forum Discussion
I need help with a Sumif formula
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.
