drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance
I have to columns names eg:
I would like to SUM the values in ColBBB if the cells in CoaAAA starts with possibilities:
=SUMPRODUCT(--(LEFT(ColAAA)={"ND","0%"})) I get 143
=SUMPRODUCT(--(LEFT(ColAAA ,2)={"ND","0%"}),ColBBB )
I get a error
What am I doing wrong?
ps: in this Eg I only put two possibilities , In my job I have many posssibilities
This is why I can't use Sumproduct + SumProduct...
I have to columns names eg:
- A2:A50 = ColAAA
- B2:B50 = ColBBB
I would like to SUM the values in ColBBB if the cells in CoaAAA starts with possibilities:
- ND
- 0%
=SUMPRODUCT(--(LEFT(ColAAA)={"ND","0%"})) I get 143
- So actually 143 rows contain ND or 0%
- If I filter on the row Source ColBBB I get a Sum 45000 after this filter
=SUMPRODUCT(--(LEFT(ColAAA ,2)={"ND","0%"}),ColBBB )
I get a error
What am I doing wrong?
ps: in this Eg I only put two possibilities , In my job I have many posssibilities
This is why I can't use Sumproduct + SumProduct...