second criteria in a sumif function

[luckypurchase]

Dear all,

I like to add a second criteria in a sumif function:

Function looks like these: =SOM.ALS(tabelBU;BJ3;Tabelspend)

Cell BJ3 = a list, furthermore I like to add another cell with a list.

Please let me know and thank you in advance

kind regards,

Lukas

 

[Aladin Akyurek]

Dear all,

I like to add a second criteria in a sumif function:

Function looks like these: =SOM.ALS(tabelBU;BJ3;Tabelspend)

Cell BJ3 = a list, furthermore I like to add another cell with a list.

Please let me know and thank you in advance

kind regards,

Lukas

Care to post what you have in BJ3? Also specify that other cell with a list which you want to add to the formula?

 

[luckypurchase]

Cell BJ3 contains a cell validation; =listregio, a list of 25 regions (North, south, etc)

The other cell contains a list of years. (2010,2011 etc)

If it is possible I like to add a third of forth validated cell with other criteria's aswell

Thanks for the fast response

Lukas

 

[Aladin Akyurek]

Cell BJ3 contains a cell validation; =listregio, a list of 25 regions (North, south, etc)

The other cell contains a list of years. (2010,2011 etc)

If it is possible I like to add a third of forth validated cell with other criteria's aswell

Thanks for the fast response

Lukas

SOM.ALS (SUMIF) works just one criterion. For more criteria, you need to invoke SOMMEN.ALS (SUMIFS) if you are on Excel 2007 or later. Otherwise something like SOMPRODUKT (SUMPRODUCT) can be used.

Examples:

=SOM.ALS(Range;Crit1;SumRange)

=SOMMEN.ALS(SumRange;Range1;Crit1;Range2;Crit2)

=SOMPRODUKT(SumRange;--(Range1=Crit1);--(Range2=Crit2))

 

[luckypurchase]

Thank you Aladin Akyurek,

I like to post a screendump of my database, though I can't attach it on this forum.

Tought if it is handy to see the database, please mail me your email on lukas.van.eeden@benefit.nl and I will send a screendump to clear up my dillema.

 

[luckypurchase]

Thank you!

 

[Aladin Akyurek]

Thank you Aladin Akyurek,

I like to post a screendump of my database, though I can't attach it on this forum.

Tought if it is handy to see the database, please mail me your email on lukas.van.eeden@benefit.nl and I will send a screendump to clear up my dillema.

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste