Feb 04 2021 06:01 AM
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
Feb 05 2021 12:52 AM
@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.
Feb 13 2021 10:50 AM
Thank you very much for your support!