Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
Display a pix from a URL in a Excel cell | Excel Discussion (Misc queries) | |||
Can 2 different hyperlinks be in the same Excel cell? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |