Summing one lot of cells based on another lot

Summing one lot of cells based on another lot

Post by Frank Kabe » Sat, 31 Jan 2004 03:59:58


Hi
one way:
=SUMIF(A2:A99,"=6767",B2:B99)

HTH
Frank
 
 
 

Summing one lot of cells based on another lot

Post by sh0t2bt » Sat, 31 Jan 2004 04:00:52

Hi All,

I have an worksheet with lists of data, like this:-

A B C D E
6767 10 5 6 7
6868 1 10 5 4
6565 75 25 1 9
6767 1 5 75 20
1234 4 78 69 54


What I want to do is sum the figures in colum B where 6767 appears in column
A. so from the above I would get 11 as the result


Any Ideas??

Cheers

Mark

 
 
 

Summing one lot of cells based on another lot

Post by Frank Kabe » Sat, 31 Jan 2004 04:06:02

an addition
=SUMIF(A2:A99,6767,B2:B99)
if column A consist of numbers
Frank
 
 
 

Summing one lot of cells based on another lot

Post by Dave R » Sat, 31 Jan 2004 04:07:20

use SUMIF(A1:A5,6767,B1:B5)

if that fails try putting 6767 in quotes.




column
 
 
 

Summing one lot of cells based on another lot

Post by sh0t2bt » Sat, 31 Jan 2004 04:26:53

cheers guys :o)



column