Excel en Mac: fórmulas que no devuelven el resultado esperado

New Contributor

Buenos días,

Tengo excel en Mac, estoy usando fórmulas como sumar.si o buscarv y no devuelven el resultado esperado. Devuelven otro al que no encuentro la lógica. ¿Podéis ayudarme?

Gracias

2 Replies

@Almudenaarci Firstly, when you use SUMIF (SUMAR.SI), the range and sum range need to be shaped the same. I have corrected the formula in H2.

 

Secondly, VLOOKUP (BUSCARV) will only find the first occurrence of "CLIENTES". I assume you want all four amounts/entries that refer to "CLIENTES". Then you need to filter them from the list. If you are an MS365 subscriber, you can perhaps already use the new FILTER function as demonstrated in K2. If not, then a simple pivot table can easily produce the list you need.

 

See attached file.

Hi @Riny_van_Eekelen 

Thank you very much for your support!