I have the following formula;

=SUMIF(AJ4:AJ123,"T1",AI3:AI122)+SUMIF(AK4:AK123," T1",AI3:AI122)+SUMIF(AL4:AL123,"T1",AI3:AI122)+SUM IF(AM4:AM123,"T1",AI3:AI122)

Basically if a cell in AJ, AK, AL, or AM has T1 in it then it sums up the
cells that are in column AI and one row above where the T1 was located.

However it still calculates cells that are hidden, how do I have it only add
up visible cells?

Any help?