How to auto total separate entries in spreadsheet?

linustalman · 04-01-2014, 08:40 AM

Hi.

In the attached spreadsheet example - How can I auto tally the full donations made to a particular charity? Getting the full total for all is easy but how can I tally for something that contains a certain term; e.g.'Cat Charity' etc?

What formula to use?

Thanks.

ericson007 · 04-01-2014, 08:43 AM

The key is a formula using the if function

linustalman · 04-02-2014, 03:32 AM

Quote:

Originally Posted by ericson007

The key is a formula using the if function

I was thinking that but don't know of the exact formula.

jdkaye · 04-02-2014, 03:48 AM

You've got loads of room; no need to skimp. If you put each charity in a different column and not all piled together in one column, then the solution is obvious. Right?
jdk

chrism01 · 04-02-2014, 04:51 AM

Even better, use a separate tab/sheet for each Charity.

ericson007 · 04-02-2014, 05:12 AM

You can also use pivot tables. That may be quickest, no need for formulas.

linustalman · 04-02-2014, 07:47 AM

Quote:

Originally Posted by jdkaye

You've got loads of room; no need to skimp. If you put each charity in a different column and not all piled together in one column, then the solution is obvious. Right?
jdk

But I'd like to have all donations ordered by date.

jdkaye · 04-02-2014, 10:05 AM

Quote:

Originally Posted by LinusStallman

But I'd like to have all donations ordered by date.

I'm not exactly what you mean. You can order them anyway you like. You can create a report and dictate exactly how you want the output ordered. That is independent of the way the cells are ordered. But I really don't understand what your problem is. Maybe you can give a bit more detail about what you're trying to do. I don't really think you have any problem doing it the way it was suggested.
jdk

linustalman · 04-02-2014, 03:09 PM

Quote:

Originally Posted by jdkaye

I'm not exactly what you mean. You can order them anyway you like. You can create a report and dictate exactly how you want the output ordered. That is independent of the way the cells are ordered. But I really don't understand what your problem is. Maybe you can give a bit more detail about what you're trying to do. I don't really think you have any problem doing it the way it was suggested.
jdk

Ok, for E2 Total the forumula is =SUM(C2:C10). For each of the others (Cat Charity, Dog Charity, etc.) I want something like (the following code is totally wrong but I'm trying to explain what I mean) if="Cat Charity" then add to SUM or something along those lines.

salasi · 04-02-2014, 03:24 PM

Quote:

Originally Posted by chrism01

Even better, use a separate tab/sheet for each Charity.

That would be one successful way of doing it. If you don't do that, and those charity names are entered manually each time, the way that you are trying to do things won't be reliable. Someone will enter 'Donkey Charity' rather than 'Donkey Charity' (or even 'Donkey charity') and you have to either find a way of preventing that (possible, but possibly ugly), making it easier to detect, or of making the thing work in spite of that.

(maybe that would have been clearer with code tags - that sort of makes the point!)