![This is a question](/images/board_posticon.gif)
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
![This is a QotW comment](/images/board_posticon.gif)
I'm doing fish fingers and potato animal shapes tonight. It's teh kind of poverty dinner I can imagine Monty having to eat, but I do it out of choice and therefore it's fun and "ironic"
( , Thu 9 Aug 2012, 12:41, 1 reply, 12 years ago)
![This is a QotW comment](/images/board_posticon.gif)
Baroness had pepperoni, peppers and jalepenoes. Both medium
We swapped a quarter with each other.
( , Thu 9 Aug 2012, 12:42, Reply)
![This is a QotW comment](/images/board_posticon.gif)
Also, I don't understand your sex slang.
( , Thu 9 Aug 2012, 12:44, Reply)
![This is a QotW comment](/images/board_posticon.gif)
you could have Dominos at the reception
( , Thu 9 Aug 2012, 12:45, Reply)
![This is a QotW comment](/images/board_posticon.gif)
Don't worry, they never invite me either, although I like to think that it's purely a distance thing in my case.
( , Thu 9 Aug 2012, 13:01, Reply)
![This is a QotW comment](/images/board_posticon.gif)
I left the mrs have a slice of mine, and then I finish off hers because she never eats a whole pizza.
( , Thu 9 Aug 2012, 12:47, Reply)
![This is a QotW comment](/images/board_posticon.gif)
You're dumped, turn to page 558
( , Thu 9 Aug 2012, 12:54, Reply)
![This is a QotW comment](/images/board_posticon.gif)
Bonus context news link www.bbc.co.uk/news/science-environment-19180983
( , Thu 9 Aug 2012, 12:57, Reply)
![This is a QotW comment](/images/board_posticon.gif)
I have a filtered column with numbers in, I want to add up the list, but it adds the entire column including those hidden rows. How do I stop it being spastic.
Yours excitedely NA
( , Thu 9 Aug 2012, 13:04, Reply)
![This is a QotW comment](/images/board_posticon.gif)
what column are you summing up?
( , Thu 9 Aug 2012, 13:14, Reply)
![This is a QotW comment](/images/board_posticon.gif)
It has a drop down filter which i've used to only show figures from Company X. I want to add these
( , Thu 9 Aug 2012, 13:17, Reply)
![This is a QotW comment](/images/board_posticon.gif)
If the company name is in column A and the numbers you want to add up are in column b, this would work
=SUMIF(A:A,"Company X",B:B)
Filters are for losers.
( , Thu 9 Aug 2012, 13:21, Reply)
![This is a QotW comment](/images/board_posticon.gif)
Filters are imperitive I have more than 4,000 rows
( , Thu 9 Aug 2012, 13:24, Reply)
![This is a QotW comment](/images/board_posticon.gif)
like this
company A
fig A
Company B
Fig B
etc?
( , Thu 9 Aug 2012, 13:26, Reply)
![This is a QotW comment](/images/board_posticon.gif)
so
company A, £3000
company B, £2300
( , Thu 9 Aug 2012, 13:28, Reply)
![This is a QotW comment](/images/board_posticon.gif)
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)
![This is a QotW comment](/images/board_posticon.gif)
to =SUMIF(#FILTERED COLUMN#,"#FILTERED BY#",N:N)
( , Thu 9 Aug 2012, 13:33, Reply)
![This is a QotW comment](/images/board_posticon.gif)
( , Thu 9 Aug 2012, 13:26, Reply)
![This is a QotW comment](/images/board_posticon.gif)
or:
ROUNDUP, COUNTIF RANK, IF NOT LARGE, GETPIVOTDATA, IMCONJUGATE.
( , Thu 9 Aug 2012, 13:30, Reply)
« Go Back | See The Full Thread