Previous Topic Next Topic

Add when multiple criteria is met in rows

Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
 - Mar 29, 2012 at 08:50 AM
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
 - Apr 13, 2012 at 11:54 AM
Hello,

I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B83:BF83 and "Boot" in row B87:BF87.

I tried =SUMPRODUCT(--(B83:BF83="A")*(B87:BF87),B115:BF115)) and a couple of other but it does not seem to be counting!

Any suggestions if it can done this way with the rows?

Thanks

2 replies

Answer 1 / 2
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Mar 29, 2012 at 02:00 PM
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
0
Answer 2 / 2
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Mar 30, 2012 at 02:29 AM
Hi rivisa 1, tried it but it does not add up at all!
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Mar 30, 2012 at 02:33 AM
could you post some sample data ?. For my sample it worked
0
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Mar 30, 2012 at 02:48 AM
RowColumn A B C D E F G
83 ROW A A B A B C
87 Product SMART BOOT SMART BOOT BOOT BOOT
115 Loaded 30000 20000 10000 18000 25000 6000

It looks like this so i want the value (A together with Boot) =28000 or A with SMART =30000 etc
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Mar 30, 2012 at 03:23 AM
Using your data i get 38000 by pasting above formula

20000 + 180000
0
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Apr 3, 2012 at 04:14 AM
Yes it work when on a clean sheet but in my workbook it dont count up, don't know if the graphs and other formulas in my workbook is working against it!
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Apr 3, 2012 at 04:39 AM
Not possible to tell without looking. Could you post your sample book on some file sharing site and post back the link the to file back here so one can see what is the issue
0