Once you have named nonadjacent range of cells and used a formula to calculate that range how can you add additional rows to be included without having to...

Okay, assume I am a total Excel dumby (which is the truth). I know only basic functions of Add, Subtract, and Multiply. However, I need to set up a payroll...

NO more new fonts may be applied to this workbook

Robin, If you want the range 14 = X = 30 use: =COUNTIF(A1:A100,"=14") - COUNTIF(A1:A100,"30") OR =SUMPRODUCT((A1:A100=14)*(A1:A100=30)) includes 14 and...

Dear, Since we had edited a file a month ago, (when it still worked) we get errors in Excel and Excel closes. This problem only occurs with one...

I have posted this question, worded differently, before in this newsgroup and have tried to follow the instructions but I'm not getting the results I would...

Hi if anyone could help me i would be grafeful, the problem im having is trying to use nested if's with vlookup tables. for...

Hi, Does anyone know how to split a text cell that contains two lines of text (created using alt enter) into two cells which each contain one line of the...

I'm working with large numbers. How can I make the result round up or down to the nearest thousand or even million? Any suggestion will be greatly appreciated.

It's easy to see data anomolies from the pivot but difficult to find them again in the flat file. Does anyone know if it's possible to change the underlying...

Is there a way to look in a cell and find a particular string of data and categorize that as "TRUE" if the string is found and "FALSE" if not? I've tried...

Hello there I'd like a work book with about 45 worksheets to always print in black and white. I've found this staement but it seems to only apply to one...

I am experienceing a strange situation. I have a workbook (with print gridlines turned on within each worksheet), when printing the entire workbook, I am...

I have a sheet with four columns! a,b,c,d Column A has nothing in it and is labeled id_fm Column B has 2870 rows of customers and is...

I have a schedule at work and there are four crews, A,B,C,D. Each crew on the schedule is a different color. I was wondering if there is a way or a macro...

I have a problem that's been hounding me for the last few days. This is a problem I have in various formulas, but here's a specific. I have a mail list, and...

I have some data that I imported from Access. In Access, it was formatted as a number, but in Excel it imported as text. I can right-click on each cell and...

Dear, Since a while ago (when it still worked) we begin to have problems with one Excel-sheet and Custom Views. The problem is that when we apply a custom...

Can you format a cell as a date

Looks like you want... =SUMPRODUCT(--(Arange=X),--(Arange=Z),--(Jrange"")) "skweetis" wrote in...