Forum Discussion
ayuda con la función sumar.si.conjunto
Divasmo Have you considered using a Pivot Table, combined with slicers? It would allow you to make all the selections you want. But, obviously, your report page will look different. Please have a look at the tab "PT" in the attached workbook.
Riny_van_Eekelen muchas gracias.
si, si lo he considerado, sin embargo debo hacerlo como está en el archivo que adjunté.
gracias por tú tiempo.
consideras que es muy complicado lo que quiero hacer?
hice cada fórmula por separado, pero al unificarlas una parte de la fórmula deja de funcionar.
seguiré intentando.
Divasmo To be honest, yes, I think you are complicating the matter enormously by using all the nested IF statements that in turn include multiple SUMIFS. It seems you are trying to replicate the functionality that is already available in e.g. pivot tables. But, I'm probably not the right person to judge.
One of your formulae, although it looks very structured, consists of 1234 characters. It may work but, I'm not surprised if it doesn't. Personally, I'm in favour of using as many helper columns/rows (out of view) as needed to avoid such long formulae. But, that's just my preference and I haven't gone so far as to analyse in detail to see if this is actually causing your problem.
