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
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Apr 13, 2012 at 11:54 AM
Related:
- Add when multiple criteria is met in rows
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add photo in word resume - Guide
- How to add songs to sound picker - Guide
- How to add watermark in word - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 29, 2012 at 02:00 PM
Mar 29, 2012 at 02:00 PM
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Mar 30, 2012 at 02:29 AM
Mar 30, 2012 at 02:29 AM
Hi rivisa 1, tried it but it does not add up at all!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 30, 2012 at 02:33 AM
Mar 30, 2012 at 02:33 AM
could you post some sample data ?. For my sample it worked
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Mar 30, 2012 at 02:48 AM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 30, 2012 at 03:23 AM
Mar 30, 2012 at 03:23 AM
Using your data i get 38000 by pasting above formula
20000 + 180000
20000 + 180000
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Apr 3, 2012 at 04:14 AM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 3, 2012 at 04:39 AM
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