I'm having problems with the SUMIF function

If I use
=SUMIF('Page 1'!$E$4:$E$260,"=A2",'Page 1'!$H$4:$H$260) I get a zero result

If I use
=SUMIF('Page 1'!$E$4:$E$260,A2,'Page 1'!$H$4:$H$260) I get an accurate
result

For my final function I want to use
=SUMIF('Page 1'!$E$4:$E$260,=A2,'Page 1'!$H$4:$H$260)-SUMIF('Page
1'!$F$4:$F$260,=A3,'Page 1'!$H$4:$H$260)
....to get the sum of days within a date range. A, E and F are all date
formatted Columns. H is a number format (days).

I also have 100 rows, so it would be good if I am able to drag =A2, so that
it updates to =A3,= A4,= A5, etc., on the cells below.

Please help!

Dylan
Scotland

"dd" wrote:
If I use
=SUMIF('Page 1'!$E$4:$E$260,"=A2",'Page 1'!$H$4:$H$260) I get a zero result

Thats trying to match a cell with "=A2" in it, rather than looking at the
value of A2. Try
=SUMIF('Page 1'!$E$4:$E$260,"="&A2,'Page 1'!$H$4:$H$260)

But i'm unsure if sumif can worth with inexact matches.

=SUMPRODUCT(--('Page 1'!$E$4:$E$260=A2),('Page 1'!$H$4:$H$260))

That should work though, and one other thing, I think its = rather than =.

Hi

It should be = not =
For the second part, wanting the comparison cell to increase as you copy
down, use
,"="&A2,

=SUMIF('Page 1'!$E$4:$E$260,"="&A2,'Page 1'!$H$4:$H$260)

--
Regards

Roger Govier


"dd" <dd.dd wrote in message
...
I'm having problems with the SUMIF function

If I use
=SUMIF('Page 1'!$E$4:$E$260,"=A2",'Page 1'!$H$4:$H$260) I get a zero
result

If I use
=SUMIF('Page 1'!$E$4:$E$260,A2,'Page 1'!$H$4:$H$260) I get an accurate
result

For my final function I want to use
=SUMIF('Page 1'!$E$4:$E$260,=A2,'Page 1'!$H$4:$H$260)-SUMIF('Page
1'!$F$4:$F$260,=A3,'Page 1'!$H$4:$H$260)
...to get the sum of days within a date range. A, E and F are all date
formatted Columns. H is a number format (days).

I also have 100 rows, so it would be good if I am able to drag =A2,
so that
it updates to =A3,= A4,= A5, etc., on the cells below.

Please help!

Dylan
Scotland

Many thanks both, especially for the super fast response.

Dylan
Scotland

"Roger Govier" wrote in message
...
Hi

It should be = not =
For the second part, wanting the comparison cell to increase as you copy
down, use
,"="&A2,

=SUMIF('Page 1'!$E$4:$E$260,"="&A2,'Page 1'!$H$4:$H$260)

--
Regards

Roger Govier


"dd" <dd.dd wrote in message
...
I'm having problems with the SUMIF function

If I use
=SUMIF('Page 1'!$E$4:$E$260,"=A2",'Page 1'!$H$4:$H$260) I get a zero
result

If I use
=SUMIF('Page 1'!$E$4:$E$260,A2,'Page 1'!$H$4:$H$260) I get an accurate
result

For my final function I want to use
=SUMIF('Page 1'!$E$4:$E$260,=A2,'Page 1'!$H$4:$H$260)-SUMIF('Page
1'!$F$4:$F$260,=A3,'Page 1'!$H$4:$H$260)
...to get the sum of days within a date range. A, E and F are all date
formatted Columns. H is a number format (days).

I also have 100 rows, so it would be good if I am able to drag =A2,
so that
it updates to =A3,= A4,= A5, etc., on the cells below.

Please help!

Dylan
Scotland