From koffice  Wed Sep 01 07:55:13 2004
From: Nicolas Goutte <nicolasg () snafu ! de>
Date: Wed, 01 Sep 2004 07:55:13 +0000
To: koffice
Subject: Re: Kspread question/help
Message-Id: <200409010955.13828.nicolasg () snafu ! de>
X-MARC-Message: https://marc.info/?l=koffice&m=109402525427577

The easiest would be with SUMIF but it has been introdiced only very recently:
http://bugs.kde.org/show_bug.cgi?id=81026

As for a workaround, I do not know.

Have a nice day!

On Tuesday 31 August 2004 21:50, Danny Angelo Carminati Grein wrote:
> -----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

____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice