All Questions
35
questions
1
vote
2
answers
180
views
I hyperlinked a cell in excel 2003, formula issues?
I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...
1
vote
3
answers
1k
views
Excel select column
In excel, if I want to perform a function with the column to the left, how do I go about this?
5
votes
4
answers
15k
views
Using two conditions with a SUMIF function in Excel 2003
For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2.
That will basically summarize all the values on my ...
4
votes
4
answers
20k
views
Excel formula to display a string of text and numbers
I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx
data1 is in column A and data2 is in column B.
the format of data1 needs to be 5 numbers (sometimes ...
1
vote
3
answers
3k
views
Sum Column, but only Filtered Rows
I have a large flat file of a bunch of ungrouped primary key values.
I want to filter on a key and populate cell A1 with the value selected from the dropdown list.
In the end, I want to see a sum of ...