Possible to do a calc on certain rows?

Hi all,

In 23 days time I am off around the world for 10 years. I have a pal
TX and have found that I can use excel spread sheets. I already have
budget set in MS ACCESS that is accessable online, but I would like
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 th
food type is used to work out the cost per day, which is why I need t
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 :

--
kotitiaher
-----------------------------------------------------------------------
kotitiahere's Profile: http://www.officehelp.in/member.php?userid=504
View this thread: http://www.officehelp.in/showthread.php?t=125710

Posted from - http://www.officehelp.i

CyberTaz
Thu Nov 09 20:38:09 CST 2006

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 kotitiahere.2h1ani@NoSpamPleaze.com,
"kotitiahere" <kotitiahere.2h1ani@NoSpamPleaze.com> 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 :)
>

kotitiahere
Thu Nov 09 22:00:48 CST 2006


thank you so much CyberTaz - the first one worked perfectly! :

--
kotitiaher
-----------------------------------------------------------------------
kotitiahere's Profile: http://www.officehelp.in/member.php?userid=504
View this thread: http://www.officehelp.in/showthread.php?t=125710

Posted from - http://www.officehelp.i