castropereira
New Member
- Joined
- May 8, 2019
- Messages
- 1
I have a table with some values that i want to sum according the year, name a store, and them according the current month...
(I want to sum the accumulated values since the beginning of the month)
I have a VLookup that gets me the text i want in the array:
<colgroup><col width="221" style="width: 166pt;"></colgroup><tbody>
</tbody>
And using a concatenate i get in the cell per. eg. F2 {[FONT=Arial, sans-serif]4,5,6,7,8,9,10,11,12}[/FONT]
[FONT=Arial, sans-serif]After getting this value i want to use it in my array:
[/FONT]=SUM(VLOOKUP(CONCATENATE(C2;C6);ORCAMENTOS!B:P;F2;FALSE))
By typing the value in F2 it all works by pressing ctr+shif+enter... with F2... no result...
i?m getting #ref as an error...
any helP
(I want to sum the accumulated values since the beginning of the month)
I have a VLookup that gets me the text i want in the array:
4 |
4,5 |
4,5,6 |
4,5,6,7 |
4,5,6,7,8 |
4,5,6,7,8,9,10 |
4,5,6,7,8,9,10,11 |
4,5,6,7,8,9,10,11,12 |
4,5,6,7,8,9,10,11,12,13 |
4,5,6,7,8,9,10,11,12,13,14 |
4,5,6,7,8,9,10,11,12,13,14,15 |
4,5,6,7,8,9,10,11,12,13,14,15,16 |
<colgroup><col width="221" style="width: 166pt;"></colgroup><tbody>
</tbody>
And using a concatenate i get in the cell per. eg. F2 {[FONT=Arial, sans-serif]4,5,6,7,8,9,10,11,12}[/FONT]
[FONT=Arial, sans-serif]After getting this value i want to use it in my array:
[/FONT]=SUM(VLOOKUP(CONCATENATE(C2;C6);ORCAMENTOS!B:P;F2;FALSE))
By typing the value in F2 it all works by pressing ctr+shif+enter... with F2... no result...
i?m getting #ref as an error...
any helP