Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition to Formula
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addition Formula | Excel Discussion (Misc queries) | |||
Formula for addition | Excel Worksheet Functions | |||
Addition & multiplication formula | Excel Discussion (Misc queries) | |||
Formula Addition Copy | Excel Discussion (Misc queries) | |||
Progressive Addition Formula | Excel Worksheet Functions |