SUMIF Function not functioning properly

[Req]

Hi,

I'm using Excel 2000.

When I run a SUMIF function it does not add up the cells which I have
outlined in the range.

E.G. Formula

=SUMIF(H22,"Test",J2222)

I have four text cells reading

H22 Test
H23 Testing
H24 Testing
H25 Test

JColumn K,L,M,N,O and P columns just have similar numbers

J22 3
J23 3.5
J24 4
J25 5

The range is J2222 and this is not being added. Instead it is giving
me the figure from J22 added to the figure from J25.

Could someone please help me, reply to my email

(e-mail address removed)

 

[Katherine Coombs]

Change your formula to:

=SUMIF(H22,"Test*",J2222)

 

[Alan Beban]

=SUMPRODUCT((H22:H25="Test")*(J2225))

I take it you meant your range is J2225, not J2222.

Alan Beban

 

[Req]

THAT'S IT!!!

It worked... thankyou very much Alan