Afonso Mira 0 Posted September 26, 2019 Report Share Posted September 26, 2019 Boa tarde tenho o seguinte problema: Tenho 2 tabelas: Tabela1 com datas; Tabela2 com datas e valores; Tenho o (SOMA.SE Data da Tabela2;Data Tabela1;VALORES) numa celula da tabela 1; Em VBA tenho o seguinte código: Folha4.Range("C7").Value = WorksheetFunction.SumIf(("R:R"), "B7", ("U:U")) Mas dá-me um erro que não percebo qual seja. Alguém me consegue ajudar? Afonso Mira 😃 Estagiando por aqui: Kemet Electronics Portugal, S.A. Link to post Share on other sites
Solution Shroeder 0 Posted October 8, 2019 Solution Report Share Posted October 8, 2019 Folha4.Range("C7").Value = WorksheetFunction.SumIf(Folha4.Range("R:R"), Folha4.Range("B7"), Folha4.Range("U:U")) Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now