Referencing columns on cells by function
Help, thanks:
I have this cell that does a sum.plus.if
(I could solve my problem by inserting the IF function but it would be long, complex and not adaptable)
So, can I make sure that the values_to_be_summed and the_values_test, which are columns, are read on two prepared cells?
That is, from:
SUMIFS(Table 1::$Value;SUPPLIERS;"="&$B$8;Table 1::$Date;">="&$A$5;Table 1::$Date;"<=" &$A$6)
to:
SUMIFS(B14;C14;"="&$B$8;Table 1::$Data;">="&$A$5;Table 1::$Data;"<="&$A$6)
where in B14 and C14 I write the columns that interest me... but it gives me an error... but can it be done? Because I would put a pop-up menu in B14 and C14 that selects the desired columns.
I think I wrote nonsense, but could it be feasible?
(so as not to go crazy with the IF function and write a mountain of variables).
iMac 27″, macOS 10.13