General

can't get excel to print more than one copy of worksheet at atim
My experience is that some printer drivers work and some don't. Replace driver or printer and driver. YMMV. Jen wrote: how do I fix this? ... 20 Jan 2010 23:03

SUMPRODUCT reference changes!!! Not what I want...
I am using SUMPRODUCT to sum a column on another worksheet. My formula looks like this: =SUMPRODUCT((Data!$E$4:$E$10000=$A$1)*(Data!$H$4:$H$10000=$A4)*(Data!$D$4:$D$10000="Y")*(Data!$J$4:$J$10000="Y")) The # of rows on worksheet DATA changes perodically. When I delete the rows in DATA and paste in new rows the... 20 Jan 2010 15:12

Conditional Formatting
I have 2 spreadsheets (#1, #2) in a workbook. Speadsheet #1 has 2 columns which are "dates of inquiries received (in cell A2:A129)" and the second is "amounts worked on inquiry in minutes (B2:B129)". Spreadsheet #2 is a summary of spreadsheet #1 and has rows in weekly increments and columns with the headings of... 20 Jan 2010 11:48

color code
I have trying to do this, but to no avail. I want cells to change color like: more than 60 days before certain date - they're green 1 - 60 days - they're yellow 0 days and days after - they're red ... 22 Jan 2010 10:40

Ink on a Protected Sheet
I need to allow users to use the inking tool on a protected sheet. When I protect the sheet, the Start Inking button is greyed. Any suggestions? -- Fishman4 ... 20 Jan 2010 14:04

formula explanation
Sorry the current formula is =SUM(IF(ISTEXT(C6:K6),1,0)) ... 20 Jan 2010 11:48

sumif but additionally there maybe filtering
Hi, Column A | Column B | Column C .... | 100 | $ .... | 50 | € .... | 60 | $ =sumif(C1:C3;"$";B1:B3) No problem until this point. But, when I appply some filtration in column A, I need the sum to change. When I write the formula as above, the s... 20 Jan 2010 10:39

rich text box in forms
I would like to use rich text boxes in my forms. I read that you can use this un-allowed tools in forms if you make a change to the browser. Does someone out there know the answer to this? -- Ed Ayers ... 20 Jan 2010 10:39

Exel only prints to a file
Running Windows 7, with MS Office 2003 SP3. Excel will only print to file, and not to my printer (Canon MP980). Have searched all print to file options, and everytyhing seems OK (the print to file option is definitely unchecked). This is only happening with Excel, all other applications (including word, PPT,) pr... 19 Jan 2010 19:13

Conditional Format not Updating
I have a conditional format in xl2007 that works (fill 9 adjacent cells), but only if I leave the page and return. This CF is dependent on the value in another cell, which can change from values 1-4 based on a groupbox radio button choice. The target cell is formatted as a "number". There are other CF's in the... 19 Jan 2010 22:34