Get instant live Excel expert help with COLUMNS Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I'm wondering if it's possible to create a sum in A3 that will add up all of the cells that say "PAP" under the "Type" list in column B?
Solved by K. B. in 29 mins
Hi, I have a column "Status" which i will like it to be automated update with value when there is a date in various columns. There are 4 columns: Status, Date of Deposit (Col 1), Date of Sending (Col 2), Date of Return (Col 3) Eg 1: Status = Deposit, when Col 1 = x date, Col 2 = empty cell, Col 3 = empty Eg 2: Status = To EHI, when Col 1 = x date, Col 2 = y date, Col 3 = empty Eg 3: Status = Complete, when Col 1 = x date, Col 2 = y date, Col 3 = z date
Solved by T. S. in 24 mins
Trying to get sum of 4 columns, but only 1 column has value at this time, will enter value in the other 3 columns each successive day (running total)
Solved by D. D. in 18 mins
I'm trying to find a formula that would automatically calculate -8 in column F when column C is either Yes or No as well as the total % for that category.
Solved by B. F. in 15 mins
I have 2 sheets (Sheet A, Sheet B) with data. Both sheets have the same item numbers. However, only 1 sheet has the correct Item SKU and Link to Image. I would like a script that that when the item number on Sheet A matches the Item number of Sheet B then the Item Number on Sheet B should be copied the correct column on Sheet A and the Link on Sheet B should be copied to Sheet A to the correct column.
Solved by M. W. in 12 mins
Hi. Please can you help! I am working on spread sheet where there is costs for depending on number of people. People Cost per person depending on the people, in the group 1-3 = 2000 4-6 = 4000 7-9 = 6000 10+ = 8000 and so on. How do I link to a column that when I put 5 it picks that's its to charge 4000? Does my question make sense?
Solved by E. C. in 24 mins
I need to know if something is possible in excel. I have a fuel tank and a gauge on the side. The gauge is in 1/4 inch encriments. Example: 4 ft 0 inches 0 4 ft 0 inhces 1/4 4 ft 0 inches 1/2 I have been creating a column like this 4-0-0 4-0-1 4-0-2 4-0-3 4-1-0 4-1-1 4-1-2 4-1-3 4-2-0 I have to do this sequence all the way to 22-11-3. If i just do 4-0-0 to 4-11-3 is there a way to tell that column to change all the 4s to 5s. That way i would just have to change the first number. Creating now 2 columns 1 with 4s and 1 with 5s?
Solved by K. W. in 15 mins
READ!!!!!!!!! Column A1 has decimal values. 0.25 represents 0' 0" 1/4 in inches. 14.25 represents 1'2"1/4 ( 1 ft 2 inches 1/4 inch) I want Feet,inches,and fraction in 1/4 increments in Column B. Based on info From A-1 SO A1 B1 0.25 0'0"1/4 14.75 1'2"3/4 36.50 3'0"1/2
Solved by D. J. in 29 mins
I would like to be able to lock a time stamp in one column after i enter data in an adjacent column. In the attached spreadsheet, I would like to have data entered in "completed by" and "supervisor review" columns and have the adjacent columns show and lock the time stamp. Also, if you notice that there are certain tows that are highlighted. Those are high priority items that are critical items. I already have the spreadsheet conditionally formatted so once the task is review by the supervisor, the highlight disappears. I would like for that conditional formatting to stick as I will need to adjust the items. Thanks
Solved by I. J. in 28 mins
I have a list of projects and their complete dates in a columns a & b respectively. I also have a summary table in which I need to detail how many of these projects completed in each month. I need to report on a month by month basis so I need to see how many projects completed in January, how many in Feb, etc, etc, just by looking at the dates in column B.
Solved by V. S. in 15 mins