Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ditto
 
Posts: n/a
Default how do i get excel to see info in one cell, look at info in anoth.

Basically this is what i can not get my spread sheet to do. I need it to look
at information in one column, then look at the number that i put in on the
same row but a different column, and total the amounts below in an area i
have set for totals. This is my attempt to explain exactly what i am trying
to do.
I have a spreadsheet that has information in columns a-i. in column c1 i
have my heading, c2 is where i start entering in information such as Travel:
lodging. In f1 i have amount as my heading and in f2 i enter in an amount for
the travel: lodging. What i am trying to do, and not sucessfully! is to have
the information total down in c23, where i have my total information.
I will be filling in other information in column c(such as Travel: meals)
and need to also have this information to total for other data that i enter
in column c.
I have tried vlookup, hlookup and also tried the IF formula and found that
i am missing something or am putting in the incorrect formula.
Please save what hair i have left!!!! --
thanks
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

sounds like you need SUMIF
=SUMIF(C:C,"Travel: lodging",F:F)
will sum the values in column F where you have the words "Travel: lodging"
in column C

hope this helps
Cheers
JulieD


"ditto" wrote in message
...
Basically this is what i can not get my spread sheet to do. I need it to
look
at information in one column, then look at the number that i put in on the
same row but a different column, and total the amounts below in an area i
have set for totals. This is my attempt to explain exactly what i am
trying
to do.
I have a spreadsheet that has information in columns a-i. in column c1 i
have my heading, c2 is where i start entering in information such as
Travel:
lodging. In f1 i have amount as my heading and in f2 i enter in an amount
for
the travel: lodging. What i am trying to do, and not sucessfully! is to
have
the information total down in c23, where i have my total information.
I will be filling in other information in column c(such as Travel: meals)
and need to also have this information to total for other data that i
enter
in column c.
I have tried vlookup, hlookup and also tried the IF formula and found that
i am missing something or am putting in the incorrect formula.
Please save what hair i have left!!!! --
thanks



  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you mean that you need to total all travel, all lodging etc

=SUMIF(C2:C22,"Lodging",F2:F22)

will sum all the amounts that has Lodging in C

Regards,

Peo Sjoblom

"ditto" wrote:

Basically this is what i can not get my spread sheet to do. I need it to look
at information in one column, then look at the number that i put in on the
same row but a different column, and total the amounts below in an area i
have set for totals. This is my attempt to explain exactly what i am trying
to do.
I have a spreadsheet that has information in columns a-i. in column c1 i
have my heading, c2 is where i start entering in information such as Travel:
lodging. In f1 i have amount as my heading and in f2 i enter in an amount for
the travel: lodging. What i am trying to do, and not sucessfully! is to have
the information total down in c23, where i have my total information.
I will be filling in other information in column c(such as Travel: meals)
and need to also have this information to total for other data that i enter
in column c.
I have tried vlookup, hlookup and also tried the IF formula and found that
i am missing something or am putting in the incorrect formula.
Please save what hair i have left!!!! --
thanks

  #4   Report Post  
JulieD
 
Posts: n/a
Default

Hi

re-reading the question... makes me want to ammend my formula to
=SUMIF(C2:C22,"Travel: lodging",F2:F22)
as you want totals on row 23

if the words "Travel: lodging" are in C23 then ammend the formula to
=SUMIF(C2:C22,C23,F2:F22)
or even
=SUMIF($C$2:$C$22,C23,$F$2:$F$22)
which means you can fill down your other categories

Cheers
JulieD

"JulieD" wrote in message
...
Hi

sounds like you need SUMIF
=SUMIF(C:C,"Travel: lodging",F:F)
will sum the values in column F where you have the words "Travel: lodging"
in column C

hope this helps
Cheers
JulieD


"ditto" wrote in message
...
Basically this is what i can not get my spread sheet to do. I need it to
look
at information in one column, then look at the number that i put in on
the
same row but a different column, and total the amounts below in an area i
have set for totals. This is my attempt to explain exactly what i am
trying
to do.
I have a spreadsheet that has information in columns a-i. in column c1 i
have my heading, c2 is where i start entering in information such as
Travel:
lodging. In f1 i have amount as my heading and in f2 i enter in an amount
for
the travel: lodging. What i am trying to do, and not sucessfully! is to
have
the information total down in c23, where i have my total information.
I will be filling in other information in column c(such as Travel: meals)
and need to also have this information to total for other data that i
enter
in column c.
I have tried vlookup, hlookup and also tried the IF formula and found
that
i am missing something or am putting in the incorrect formula.
Please save what hair i have left!!!! --
thanks





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract hyperlink string from excel cell Ryan Sapien Links and Linking in Excel 1 January 20th 05 01:24 AM
I have typed in an excel cell and cannot advance to next cell by . aneruth Excel Discussion (Misc queries) 1 January 14th 05 03:34 AM
Display a pix from a URL in a Excel cell Pilot007 Excel Discussion (Misc queries) 1 December 27th 04 01:22 AM
Can 2 different hyperlinks be in the same Excel cell? rynes01 Excel Worksheet Functions 2 December 7th 04 06:15 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 03:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"