Ask Your Question
0

Taking sum according to text value in a different column.

asked 2017-10-05 08:43:22 +0200

bayindirh gravatar image

I'm building a financial table and trying to take some totals according to different criteria. Every row have a different criteria, and the criteria is stored in the same row.

A figure worth a thousand words, so below is what I'm trying to achieve:

| Expense     | Criteria | Jan  | Feb  | ... |
|-------------|----------|------|------|-----|
| A           | Here     | 1000 | 900  | ... |
| B           | There    | 250  | 300  | ... |
| C           | Here     | 400  | 125  | ... |
| Here Total  |          | 1400 | 1025 | ... |
| There Total |          | 250  | 300  | ... |

I've tried SUMIF and SUMIFS, but I was unable to succeed. Any help is greatly appreciated.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-10-05 09:11:51 +0200

robleyd gravatar image

Based on the sample data above sumif.ods does what you need using SUMIF()

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

Comments

Thanks for the answer. That's really what I've wanted.

bayindirh gravatar imagebayindirh ( 2017-10-05 12:59:29 +0200 )edit
0

answered 2017-10-05 09:03:10 +0200

pierre-yves samyn gravatar image

Hi

For example wih SUMIF, see SumForText.ods

Regards

edit flag offensive delete link more

Comments

Thanks for the example!

bayindirh gravatar imagebayindirh ( 2017-10-05 12:59:38 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-05 08:43:22 +0200

Seen: 507 times

Last updated: Oct 05 '17