sumif formula

[jenw]

At the moment I am trying to work a sumif formula

The problem I am encountering is once I have set the range and criteri
it won't pick up the sum range as the range I am specifying is fo
example J15:CB45 - it will pick up J15:CB15 but I need it to pick u
the whole range - do you know of anyway I can resolve this.

My formula is =sumif($J$3:$CB$3,E$3,($J15:$CB45)) but it doesn't see
to work this one does though =sumif($J$3:$CB$3,E$3,($J15:$CB15)) bu
that doesn't help me!

I have put a print screen of the spreadsheet I am trying to work on.

Thanks

Jenni

 

[Jerry W. Lewis]

=SUMPRODUCT(($J$3:$CB$3=E$3)*($J15:$CB45))

$J15:$CB15 is the only part of $J15:$CB45 that corresponds to your match
randge of $J$3:$CB$3, so that is all that SUMIF considers. To logically
expand the match range, you need an array formula, which SUMIF will not
handle.

Jerry

 

[Newbie]

I have tried the following and it seems to work ok - I am using Excel XP

=SUMIF(A5:CB45,A2,A5:CB45)