![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
There really should be a program for what I want to do:
Assign a list of numbers (positive and negative) I have in a CSV file to catagories (named with arbitary strings) whilst looking at a description of them also held in the CSV file
Easily generate a pie chart showing the total number in each catagory.
Currently I am doing it with a spreadsheet, which works but is kind of tedious as it doesn't have an 'okay, give me a total of everything in column Y where column X has the value Foo' function.
Assign a list of numbers (positive and negative) I have in a CSV file to catagories (named with arbitary strings) whilst looking at a description of them also held in the CSV file
Easily generate a pie chart showing the total number in each catagory.
Currently I am doing it with a spreadsheet, which works but is kind of tedious as it doesn't have an 'okay, give me a total of everything in column Y where column X has the value Foo' function.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2004-10-05 07:38 am (UTC)From:I can't remember the order exactly, but it's something like
=SUMIF(A1,Sheet1!X:X,Sheet1!Y:Y) would look up in column X everything that contained what was in A1 and add up the totals in column Y that matched. If you just wanted to count them, you'd use COUNTIF. Is this what you meant?
no subject
Date: 2004-10-05 09:03 am (UTC)From: