SUMIF Problem

[dd]

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

 

[Guest]

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 =>.

 

[Roger Govier]

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)

 

[dd]

Many thanks both, especially for the super fast response.

Dylan
Scotland

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)