[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]