Off Topic
Are 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.
( , Sun 1 Apr 2001, 1:00)
Are 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.
( , Sun 1 Apr 2001, 1:00)
« Go Back | See The Full Thread
How do you mean all in one column?
like this
company A
fig A
Company B
Fig B
etc?
( , Thu 9 Aug 2012, 13:26, 1 reply, 12 years ago)
like this
company A
fig A
Company B
Fig B
etc?
( , Thu 9 Aug 2012, 13:26, 1 reply, 12 years ago)
Or so that they're in the same cell
so
company A, £3000
company B, £2300
( , Thu 9 Aug 2012, 13:28, Reply)
so
company A, £3000
company B, £2300
( , Thu 9 Aug 2012, 13:28, Reply)
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.
( , Thu 9 Aug 2012, 13:31, Reply)
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.
( , Thu 9 Aug 2012, 13:31, Reply)
Well you could have just changed the formular I gave you
to =SUMIF(#FILTERED COLUMN#,"#FILTERED BY#",N:N)
( , Thu 9 Aug 2012, 13:33, Reply)
to =SUMIF(#FILTERED COLUMN#,"#FILTERED BY#",N:N)
( , Thu 9 Aug 2012, 13:33, Reply)
« Go Back | See The Full Thread