Ask Your Question
0

Can I use a filter to sum a group of noncontiguous cells?

asked 2016-02-29 22:54:13 +0200

JimmyJimbo gravatar image

I would like to use a category column that will hold a value that I can use for a filter when summing a range of cells in another column that have numerical values. Is that possible?

edit retag flag offensive close merge delete

Comments

Please detail a bit how data are disposed?

m.a.riosv gravatar imagem.a.riosv ( 2016-03-01 01:54:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-03-01 12:30:04 +0200

Lupp gravatar image

What about?
=SUMIF(CategoriesRange;Criterion_FilterValue;ValuesRange) or
=SUMPRODUCT(ValuesRange;CategoriesRange=Criterion_FilterValue)
(Corresponding ranges dimenioned identically!)
Consult help texts. Also AVERAGEIF, SUMIFS, AVERAGEIFS... Most versatile is SUMPRODUCT.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-02-29 22:54:13 +0200

Seen: 245 times

Last updated: Mar 01 '16