Converting google sheet formula into excel formula Help!!!

[joegonzalez]

Quick summary:
This is for my stock portfolio, I want this formula to find stocks with the same ticker in my transaction sheet and calculate the total stock into my summary sheet. This issue is that the original formula was created on google sheets and I'm having trouble copying this formula into excel. I've tried manually writing this formula, but it does not work.

Any advice would be apprenticed !!

 

[DSCfromCFA]

G'day Joe,

You may want to be more specific about what doesn't work with the formula. (What is the result when executing the formula one step at a time?)

Whilst I am far from an experienced Excel user, I an unaware of the 'filter' in your formula being an Excel function, although it could be a UDF or a named range, but you may also explain what 'filter' is meant to do in the formula.


Cheers

shane

 

[Fluff]

Filter is one of the new dynamic array functions, which is only available on 365.
Please post some sample data using the XL2BB add-in.

 

[joegonzalez]

Filter is one of the new dynamic array functions, which is only available on 365.
Please post some sample data using the XL2BB add-in.

This is my share column from my summary sheet

Stock Port. .xlsm
	J
2	Shares
3
4	0
5	0
6	0
7	0
8	0
Summary

I want this to automatically update whether I bought or sell a stock for any given date.

Stock Port. .xlsm
	B	C	D	E	F
1	Stock	Type	Shares	Price	Fees
2	Main Street Capital Corp (XNYS:MAIN)
3	Coca-Cola Co (XNYS:KO)
Transaction Info

Cells with Data Validation
Cell	Allow	Criteria
C2:C3	List	Buy, Sell, Div

For some reason, the formula that I inputted is not working.

Thank you for your interest in helping me out, I appreciate it !!

 

[joegonzalez]

G'day Joe,

You may want to be more specific about what doesn't work with the formula. (What is the result when executing the formula one step at a time?)

Whilst I am far from an experienced Excel user, I an unaware of the 'filter' in your formula being an Excel function, although it could be a UDF or a named range, but you may also explain what 'filter' is meant to do in the formula.


Cheers

shane

I've posted a sample data above. Hopefully, this helps you understand what exactly I mean.

I also want to thank you for your interest in helping me out Shane!