What you described is what SUMIF does... =sumif(b2:b10,441,c2:c10). The
second argument is what to look for, the first is where to look for it, and
the third is what to add upon finding it.
> I have a spreadsheet that has (among many other things) three columns of data
> for one farm. (see abbreviated example below) One is a field identifier, the
[quoted text clipped - 16 lines]
> f 443 11.1
> TOTAL 56.9
soilcon1 - 22 Dec 2005 00:03 GMT
That is awsome! Thanks so much, that's exactly what I needed.
> What you described is what SUMIF does... =sumif(b2:b10,441,c2:c10). The
> second argument is what to look for, the first is where to look for it, and
[quoted text clipped - 20 lines]
> > f 443 11.1
> > TOTAL 56.9