I have a macro (see below) and it works great.  The only problem I am having
is that I want to be able to see in locked cells, and the macro only lets me
go into unlocked cells. I do not want to change the locked cells, just be
able to see formula and where it comes from.  Could ...

Can someone please tell what I am doing wrong with the following sumif
statement?  When I try each piece separatly I get a number but when I put
them together Excel says something is wrong.
sumif(QueryFromAccessRedo!E:E,"=#N/A",sumif(QueryFromAccessRedo!B:B,"*NR" ...

I have this formula  {=AVERAGE(IF($A$10:$A$5066=A6,B$10:B$5066))}. As far as
my knowledge goes, i do not see anything wrong with the formula but why is
calculating a different average than the normal
=AVERAGE(number1,number2,number3....) formula?

i am using excel 2003.  i need to take today's date and add 6 weeks to it
(+42) and have that date remain constant.
if i use now or today, date changes each time i open spread sheet or refresh
it.

I have a macro enabled worksheet that is sent via e-mail to my suppliers. One
of my suppliers can not receive this e-mail. They are saying that their
firewall will not allow the attachment to come through due to the macros in
the worksheet. What can I do, or what do they need to ...

I want to count the number of Saturdays between 2 specifed dates.
i.e. between 1 Jan 08 and 31 Jan 08 there are 4 Saturdays.  
Can anyone help please?
Thanks,

I need a formula or a mathematic help. Basicaly i have 6 cells. I need to
tell it to be
0.1 when 1 cell if filled in
0.2 when 2 cells are filled in

working in excel 2003.
i have 2 s/s A & B.  when i update one of cells in s/s  A, the date is
automatically entered into col a.  
when i enter data into s/s B it's updated into col o of s/s A using

I have one table with one column for salesrep names. My second table has the
salesrep name, customer names and amounts. What I would like to do is create
a worksheet that will give me the customer names and amounts for each
salesrep.  

I am reviewing a workbook that has multiple spreadsheets of similar
data that are referenced on a “Total Costs” sheet.  Right now we use
some pretty cumbersome formulas on the Totals sheet that I want to
clean up.  I am trying to use 3D references, actually 3D Named Ranges

Hi - I have a date that is currently for example 9/28/2007 that I wish to
just say 2007 - but I want to keep the other date as is - can I create a
formula in the column beside it to adjust the date next to it and copy it
down and if so what would that formula be?  Thanks so much!

How do i get rid of duplicate entries in a spreadsheet?

Hey guys, thanks a ton for your help with this. I am by no means an excel
expert, lol, I suck. I have a spreadsheet that looks like this:
   A      B                 C
1  1:     blah1:          data  

I have two data sets each measuring windspeed at different, nearby,
locations.  Meaurements were taken at varying intervals during the
same period, (site 1 about every 2 mins, site 2 about every 8
minutes).  What I need to do is assess whether the data from one site

I have a long macro which generates a report with a weekly ammount of data.  
When I pull up data from the whole year I get the error 6  "overflow" and the
line
oursupply=(oursupply/totalsupply) is higlighted.