Off TopicAre you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.
(
rob, Sun 1 Apr 2001, 1:00)
« Go Back | See The Full Thread
done it by hand now....it's a list of numbers in column N, I have added a filter to another column so only compnay A's results show in column N, but running a sum across all tyeh visible cells in column N adds up the now hidden cells as weel, whcih is bent.
(
Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:31,
1 reply,
13 years ago)
Well you could have just changed the formular I gave youto =SUMIF(#FILTERED COLUMN#,"#FILTERED BY#",N:N)
(, Thu 9 Aug 2012, 13:33, Reply)
« Go Back | See The Full Thread