We have been able to conditionally sum a column of cells (sum_range) based on the blank cells in another column (range) using SUMIF(A$8:A20,"",B$8:B20). ...

I am using an invoice template I designed that pulls records from an Access 2007 query. The number of records imported changes each time the template is used...

Hi , I am trying to set upo a spreadsheet to track stock market purchases,dividends etc. I have date columns, however I would like to be able to color code...

List Price:$15.99 Image: http://bestdeallocator.info/image.php?id=B000V63OTM Best price found: http://bestdeallocator.info/index.php?id=B000V63OTM

i want to make conditional dropdown like this if a1="x" dropdown in a2 should be US,CANADA,MEXICO if a1="y" dropdown in a2 should be ...

When I format a cell using the "Comma Style" toolbar button, I get 2 decimal places shown along with the comma separated thousands. Is it possible to change...

is there any options or macros avialable for creating multiple y axis in the xy chart. my application is that i want plot a graph for various values at a time...

With my issue of Excell 2007 I cannot make the unhide column work. I can hide columns but cannot reverse and unhide them,either by going to thr formate...

Hello, Is there a way to compare numbers in a column and return the numbers once. Example: a b c d e f 300 ...

How do i Attach th text box on the right hand side corner of the sheet and hide it their and when i take mouse their it comes out.

Example given of a variable length (library) list, but which may actually be 1000 long. How can I transpose the data into a Table in either Excel or...

ive set up a spreadsheet to calculate my income per week. I now would like to make my tax and national insurance boxes to be calculated automatically. meaning...

Mike, Caution: the techinque I'm going to share can have unintended consequences. Let me explain. If you hold the Ctrl key down and select the tabs of the...

Hi, can you tell me how to get statistics on five different colums of numbers: specifically, how to get means and st. errors of every row in five...

I have made several extensive macros in Excel to speed up my work but after a couple of days they are no longer avaiable. How can I save these for more than a...

BlankAnd as a second thought. In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my...

Hi everyone, ('scuse my English please I'm still learning) I'm not too good at Excel and I'm working on our mock assignment at the moment, what I wanted to...

I have a list of sales for Canadian and US Customers. I marked in the column besides the sales amount if it is CDN or US. How can I add the CDN or the US...

I am trying to set up a spreadsheet with driving test results including one column to say pass one to say fail and calculate the percentage of each on a...

JUST TRYING TO GET A CELL TO CONVERT "0830" (WHEN TYPED IN TO IT ) TO SHOW 08:30 IN THE CELL. OR "1400" TO SHOW 02:00 pm OR 14:00 - JUST TRYING TO MAKE THE...