I have this formula =SUMIF(Daily!$B$5:$B$3000,D21,Daily!$E$5:$J$3000) and it
only sums col E, not E,F,G,H,I, and J. I have tried Ctrl, Shift, Enter also.
Col B is dates, D is dates ( in a different sheet), and E:J are amounts.
What have I done wrong??

Hello Again
in column A i have 31 cells representing a 31 day month using tha =a2+1 for
all 31 days, but some months have less, so the eg: below is a pain to look at.
Is there a way to make the non matching dates, to be not visible when the

If I have the following in an excel sheet:
7GH467
8SE65D
59FRS5

I got a huge database of fruit related terms such as :
apple
apple pie
apple ipod

Any ideas as to what may be causing the problem below?  When I copy the
forumul to the cell above it, the COLUMN() references are mess up.  I
was under the impression that COLUMN () was preferred over simply
putting in the column number.

Date : 10th April 2006
From
Fitzol
Dear Gentlemen,

a really picky question, why does the data validation allow a space
after the list value?
for instance, I have data validation to allow "yes" or "no" and I have
some other sumproducts looking to these cells to give me figures, but

I have the following data:
Account     External ref 2    Value
5950.799.MR05    976    158.64
5950.799.MR10    976    84.96

In Excel, is there any way to do conditional formatting that responds
to more than three conditions.
All I need to do is to give a cell one of five colors in the cell
background color, based on the cell's value being in one of five ranges

I have a column in a spreadsheet with repeated values for e.g  a name which
is repeated 5 times I would like to keep the last row containing this value
but delete all previous rows i.e in this example i would like to keep row
five containing the last occourence of this value and ...

I have a sheet containing values as follows.
                    April  May  June
company 1      43
company 2                        5

Is there (or can there be) a macro or a function that changes a formula like
=C1*$R4   in  =round(C1*$R4;0)  etc.
I have many spreadsheets with hundreds of formulas on each sheet that need
to be rounded. I would have to change individually every single formula. Is

I have 3 columns:
Month
Product
Hours

Can I alter a cells drop down menu options so I can select two different
options?

a really picky question, why does the data validation allow a space
after the list value?
for instance, I have data validation to allow "yes" or "no" and I have
some other sumproducts looking to these cells to give me figures, but