[prev in list] [next in list] [prev in thread] [next in thread]
List: koffice
Subject: Kspread question/help
From: Danny Angelo Carminati Grein <valgrind () bitcrafters ! com ! br>
Date: 2004-08-31 19:50:04
Message-ID: 200408311950.14719.valgrind () bitcrafters ! com ! br
[Download RAW message or body]
-----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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic