I am trying to sum a column.. series goes like this... $306, $200CR, $500... I want to add the cells that do not end with CR.. how??

When I use cells from a pivot table for a formula outside of the pivot table, the cell reference is locked to...

---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the...

Hello I created a worksheet with several data validation lists. However, none of them shows up as a drop down list when that cell is selected. I checked that...

I always have to re-write the formula to convert kilobytes to megabytes to gigabytes. It would be nice if excel had this availible out of the box, maybe in...

Hi, After opening the .csv file i want to save the new documen. I see the message: ..CSV may contain features that ere not compatible with CSV. I need it to...

I need to unprotect a worksheet in excel 2003, and I don't remember the password.

How to link cells so that if one is not answered then the other cannot be filled...

I inherited a workbook that has a link to another workbook that no longer exists. Every time I open this workbook, a message pops up that it can't find the...

HELP!!! This may be a basic question, but it's giving me trouble. I'm trying to set up a worksheet where by inputing a value in a cell, it changes the value...

Hi, I have a worksheet in excel and column A can have the value 'Yes' or 'No' I want to copy the excel to powerpoint (using paste special, paste link,...

I have a range of prices in column A. In column B, I put a check next to what I'd like to order. The bottom of Column A should only total values that have a...

There has to be a way to hold the numbering format in excel spreadsheet when it converts to data source for mail merging. Help!

I have a Excel Spreadsheet that keeps up with my stock purchases. I also have set-up a chart to graph my progress. What I want is for a macro to take the...

Pls. if any one has any info.. I ve worked out and cleaned up a macro to automatically import external data from multiple sources,lookup and match table...

Hello group. I've delved into the acrhives for this topic but haven't seen it specifically addressed. I have two columns of values ("E" is 480 rows and "J"...

How to keep sheets displayed(arranged) when moving between them?

The current date and time pulls but it does not specify am or pm. How can I write a formula that will show the current time as am or pm?

My database has columns headed with food sales, bar sales, net sales, etc.. The rows are numbered by day of week, with the day of the week in the next column. ...

My Data Table looks as so. Products across Row1 and Salespeople down ColA. DataTable A B D Z 1 100 500 100 99 2 50 200 100 200 6 0 500 100 99 10 0 0 100 0 I...