-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, i dont know if here is the best place to ask this question, but .. its possible to do something like find rows that have text "text" in X col cells? Like this: A B 1 10 text 2 -5 other 3 -6 text 4 1 text 5 18 other What I want is to locate all rows that have "text" in column B .. then i will calculate the sum of these row but from column A .. in this case, I need get this result: ... C D 10 text other 11 15 13 where 15 == sum of all cells relative to text "text" and 13 == sum of all cells relative to text "other" ... This is because I need do a sheet that will separate types of expenses and do especial calcs with these... Thanks - -- Danny Angelo Carminati Grein -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBNNZs3bTZQYPv0SMRAiWnAKCzqXvBnNiiosGz5oKOE9nTVv2MiQCfSmXi Mh+9Xf1EKFYw1iWjVBNe1mk= =K/Iy -----END PGP SIGNATURE----- ____________________________________ koffice mailing list koffice@mail.kde.org To unsubscribe please visit: https://mail.kde.org/mailman/listinfo/koffice