On 2002-09-16 13:45, simonf wrote:
I have colums: apple, banana, orange, pear, grape in row 1. The data are in row 2. I would like to sum only apple, orange, grape. Can it be done by SUMIF? Seems like it only allows on condition such as "apple". Thanks.
On 2002-09-16 14:03, simonf wrote:
Unfortunately, the data are in rows. I've actually considered both of your methods and was wondering if there's a shorter way of doing it. Thanks for all the helps anyway.