How to apply correctly SUM INDIRECT to non continuous column?

Hi all,


What i'm trying to achieve is the sum of 2 cells located in non continuous column,
my main purpose is to keep at all the time the same cell references with formulas.
(i have to apply INDIRECT in a hundreds of cell that use different formulas)
i used various (and some insane lol ) formulas and I'm receiving an REF Error or ####

Cell F4 have 1 and Cell H1 have 0,

these are the following formulas applied with not success

=SUM(INDIRECT("F4,H4"))
=SUM(INDIRECT(F4,H4)) 
=SUM(INDIRECT(F4":"H4))
=SUM(INDIRECT("F4"",""H4"))

Thank you in advance

One way...

=SUM(SUM(INDIRECT({"F4","H4"})))

That formula will ALWAYS refer to F4 and H4 no matter what!

You're welcome. Thanks for the feedback!