Add when multiple criteria is met in rows
Solved/Closed
Gouws
Gouws
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Gouws
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Related:
- Add when multiple criteria is met in rows
- Insert rows with data when criteria is met ✓ - Forum - Excel
- Excel vba to copy and paste rows if multiple conditions is met ✓ - Forum - Excel
- Excel vba copy rows to another worksheet based on multiple criteria ✓ - Forum - Excel
- Isnumber(search multiple criteria) ✓ - Forum - Excel
- .attachments.add vba multiple ✓ - Forum - Excel
2 replies
rizvisa1
Mar 29, 2012 at 02:00 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 29, 2012 at 02:00 PM
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
Gouws
Mar 30, 2012 at 02:29 AM
- 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!
rizvisa1
Mar 30, 2012 at 02:33 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 30, 2012 at 02:33 AM
could you post some sample data ?. For my sample it worked
Gouws
Mar 30, 2012 at 02:48 AM
- 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
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
rizvisa1
Mar 30, 2012 at 03:23 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 30, 2012 at 03:23 AM
Using your data i get 38000 by pasting above formula
20000 + 180000
20000 + 180000
Gouws
Apr 3, 2012 at 04:14 AM
- 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!
rizvisa1
Apr 3, 2012 at 04:39 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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