Re: Possible to do a calc on certain rows?

One option-

Assuming the data range is a1:d20, in G1,G2,G3 (whatever cells you wish)
enter:

=SUMIF($A$2:$A$6,"food",$B$2:$B$6)
=SUMIF($A$2:$A$6,"accommodation",$B$2:$B$6)
=SUMIF($A$2:$A$6,"sightseeing",$B$2:$B$6)

In G4 just use =SUM(G1:G3)

If you need the number of occurrences for each category you can use the
COUNTIF in the same way.

HTH |:>)
Bob Jones
[MVP] Office:Mac


On 11/9/06 8:07 PM, in article (E-Mail Removed),
"kotitiahere" <(E-Mail Removed)> wrote:

>
> Hi all,
>
> In 23 days time I am off around the world for 10 years. I have a palm
> TX and have found that I can use excel spread sheets. I already have a
> budget set in MS ACCESS that is accessable online, but I would like a
> budget in Excel so I can keep up to date as we travel around.
>
> In my budget I have the following columns
> (A1) Type (food, accommodation)
> (B1)Price
> (c1)Days
> (d1)Place
>
> then the following rows have the main information
> (A2)accommodation
> (B2)100.00
> (c2)2
> (d2)Auckland
>
> (A3) food
> (B3)60
> (c3)2
> (d3)Auckland
>
> (A4)Sightseeing
> (B4)40
> (c4)1
> (d4)North Shore
>
> Now is it possible to do something like
>
> select all days (column c) where type = food (column b)
> and then sum the total?
>
> The way that the budget (in access) works is that the days under the
> food type is used to work out the cost per day, which is why I need to
> be able to call the sum of the days for food only!
>
> Advise on how to do it and how to enter it would be most appreciated!
>
> thank you for your time
>