Hi guys
I'm trying this formula and of course it works, but....
The formula is : =SUM(SUMIFS(Sales[TotalN],Sales[CC No],A10,Sales[TipoDoc],{"FACFO","NC"},Sales[ProfData],X2))
What i would like is to get "FACFO" and "NC" on lines A2 and B2. Something like this :
=SUM(SUMIFS(Sales[TotalN],Sales[CC No],A10,Sales[TipoDoc],{A2,B2},Sales[ProfData],X2))
I know that this is wrong. Is there a way of putting it right?
Many thanks to you all
Best regards
Pedro
Bookmarks