Sumproduct based on relative cell
Solved/Closed
Brian
-
Aug 19, 2015 at 12:38 PM
BrianP Posts 1 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 02:07 PM
BrianP Posts 1 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 02:07 PM
Related:
- Sumproduct based on relative cell
- Excel macro to create new sheet based on value in cells - Guide
- If a cell has text then return value ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Count if cell contains number - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
2 responses
BrianP
Posts
1
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015
1
Aug 19, 2015 at 02:07 PM
Aug 19, 2015 at 02:07 PM
Above is an example.
With sumproduct I can sum up the two amounts for Central Auto Parts and JS Safety,based on the "Dollar Amount" text entry in column A.
I want to add another condition however, which is that column D has an "MBE" entry, but it's a cell entry two columns to the right and 4 rows up relative to each dollar amount
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 19, 2015 at 01:08 PM
Aug 19, 2015 at 01:08 PM
Brian, Good afternoon.
No problems.
BUT...the range MUST have same size.
eg.: =SUMPRODUCT((A1:A10="a")*(C31:C40>35)*(X1044:X1053))
ALL of them have 10 CELLS.
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
No problems.
BUT...the range MUST have same size.
eg.: =SUMPRODUCT((A1:A10="a")*(C31:C40>35)*(X1044:X1053))
ALL of them have 10 CELLS.
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão