Well seeing as you didn't answer my questions.
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.
(PsychoChomp, Thu 9 Aug 2012, 13:21, 3 replies, latest was 12 years ago)

You're like an Excel Yoda.

(Bazongaloid, Thu 9 Aug 2012, 13:24, Reply)

Oh soz, no all in one column
Filters are imperitive I have more than 4,000 rows
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:24, Reply)

How do you mean all in one column?
like this
company A
fig A
Company B
Fig B

etc?
(PsychoChomp, Thu 9 Aug 2012, 13:26, Reply)

Or so that they're in the same cell
so
company A, £3000
company B, £2300
(PsychoChomp, 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.
( Naked Ape call me Caitlyn, 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)
(PsychoChomp, Thu 9 Aug 2012, 13:33, Reply)

Is that one row for each individual customer of the particular supermarket branch whose data you are analysing?

( tangledupinblue hairy badge with moving eyes, Thu 9 Aug 2012, 13:26, Reply)

what excel formulas do use to make girls like me?

( glued eel /questions/questionsyoudliketoask/post1648081, Thu 9 Aug 2012, 13:25, Reply)

=VLOOKUP(skirts)

(PsychoChomp, Thu 9 Aug 2012, 13:26, Reply)

excelols

( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:29, Reply)

=IF("age"<18, SIN(), STDEV())?

( glued eel /questions/questionsyoudliketoask/post1648081, Thu 9 Aug 2012, 13:42, Reply)

SORT (yourself, out)
or:
ROUNDUP, COUNTIF RANK, IF NOT LARGE, GETPIVOTDATA, IMCONJUGATE.
(localboy purveyor of pisspoor puns, Thu 9 Aug 2012, 13:30, Reply)