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

Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
If cell contains multiple text how to add other cell value?
Iza -
TrowaD -

1 response
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses