loop in excel without using VBA or macros

Question

I have a table in Excel where I have categories and money like so:

enter image description here

I want to calculate the sum of all A category and B And C.
So I have to put a rule like this for the cell B1

=if(cell next B1 witch is A1="a";get B1)

and do the same for all other cells in B row.

How can I get the total of money collected from category A and from category B?

Look up Pivot Tables.

user2140261
– user2140261

2013-10-18 16:15:38 +00:00
Commented Oct 18, 2013 at 16:15 — user2140261
– user2140261, Commented Oct 18, 2013 at 16:15

Dan · Accepted Answer · 2013-10-18 15:37:39Z

3

Have a look at the SUMIFS function. For example, in E2 you might put

=sumifs(b$2:b$19, a$2:a$19, d2)

answered Oct 18, 2013 at 15:37

Dan

4,55220 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sous2817 Over a year ago

sumifs may be overkill because the OP only has a single criteria. Plus that function is only available in Excel 2007 and greater.

Dan Over a year ago

@sous2817 True, but I tend to prefer it over SUMIF for maintainability reasons: if I need to add more conditions later, and it's a SUMIF, I have to re-order the parameters to convert it to SUMIFS.

Prashant Kumar · Accepted Answer · 2013-10-18 15:58:00Z

If I understand you correctly: in cell E2 use the following formula:

=SUMIF($A$2:$A$19,D2,$B$2:$B19)

and copy down. Change the ranges to suit your situation.

Ryan · Accepted Answer · 2013-10-18 15:41:34Z

use SumIf this checks Col A for the character "a" and adds up the value in B

=SUMIF(A:A,"a",B:B)

Collectives™ on Stack Overflow

loop in excel without using VBA or macros

3 Answers 3

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Related