Add when multiple criteria is met in rows
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
29 Mar 2012 à 08:50
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 13 Apr 2012 à 11:54
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 13 Apr 2012 à 11:54
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 at the rate in laptop - Guide
- How to add multiple lines in excel - Guide
- How to add a checkmark in word - Guide
- T mobile add authorized user - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
29 Mar 2012 à 14:00
29 Mar 2012 à 14:00
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
30 Mar 2012 à 02:29
30 Mar 2012 à 02:29
Hi rivisa 1, tried it but it does not add up at all!
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
30 Mar 2012 à 02:33
30 Mar 2012 à 02:33
could you post some sample data ?. For my sample it worked
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
30 Mar 2012 à 02:48
30 Mar 2012 à 02:48
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
30 Mar 2012 à 03:23
30 Mar 2012 à 03:23
Using your data i get 38000 by pasting above formula
20000 + 180000
20000 + 180000
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
3 Apr 2012 à 04:14
3 Apr 2012 à 04:14
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Apr 2012 à 04:39
3 Apr 2012 à 04:39
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
