Grouping certain values associated with a specified value/criteria

[Anithmuk]

So I have about 5 columns of data each with 200 values, is there a way of finding and/or grouping all the values in one column that are associated with a value in another column?

So for example, column 2 says 'number of days' and column 4 says 'expenditure'. Is there a way to find all the values in the expenditure column that correspond to a value of '2' in the number of days column? Preferably in a way that groups the expenditure values to allow easy calculations of the sum,range, average, etc.

Thanks.

 

[Aladin Akyurek]

Try something like...

Control+shift+enter, not just enter:

=SUM(IF(DaysRange=2,IF(CategoryRange="Expenditure",ValueRange)))

Also a good option: Run a pivot table on your data.

 

[Anithmuk]

Hmmm didn't quite work, I guess I'm doing something wrong (I don't know much about excel).

What does a pivot table do?

Thanks.

 

[Aladin Akyurek]

Hmmm didn't quite work, I guess I'm doing something wrong (I don't know much about excel).

What does a pivot table do?

Thanks.

Why not? Did you substitute real ranges for the placeholders I used?

 

[Anithmuk]

Don't worry, got everything working now. Thanks for the help!

 

[Aladin Akyurek]

Don't worry, got everything working now. Thanks for the help!

Great. Thanks for providing feedback.