I can't quite work this out.

I want to sum a group of numbers dependant on the criteria in the row.

it looks like this:

Rural Town 0 0 0 0 0 8865
CBD 3596 4205 3853 3841 4028
Rural Town 5463 5503 6065 5953 5915 6056
Suburban 0 6739 6999 7604
CBD 0 0 0 5220 5138
Rural Town 4918 4721 5218 5810 5284 5180
Rural Town 0 0 0 7265 7403 7790

I only want to sum the CBD, or rural etc

Any ideas anyone on how the sumif would work?

Thanks in advance.

PS, I can't sort them so need to do it in a formula.


--
robi
------------------------------------------------------------------------
robi's Profile: http://www.excelforum.com/member.php...o&userid=24431
View this thread: http://www.excelforum.com/showthread...hreadid=546329

Total
CBD 57 8 2 67
A 56 2 3 61
Rural 5 56 4 65
CBD 65 84 65 214
=SUMIF(A2:A5,"=CBD",E2:E5)
=SUMIF(A2:A5,"=Rural",E2:E5)
=E6+E7


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546329

Hi!

Try this:

=SUMPRODUCT((A1:A7="cbd")*B1:G7)

Biff

"robi" wrote in message
...

I can't quite work this out.

I want to sum a group of numbers dependant on the criteria in the row.

it looks like this:

Rural Town 0 0 0 0 0 8865
CBD 3596 4205 3853 3841 4028
Rural Town 5463 5503 6065 5953 5915 6056
Suburban 0 6739 6999 7604
CBD 0 0 0 5220 5138
Rural Town 4918 4721 5218 5810 5284 5180
Rural Town 0 0 0 7265 7403 7790

I only want to sum the CBD, or rural etc

Any ideas anyone on how the sumif would work?

Thanks in advance.

PS, I can't sort them so need to do it in a formula.


--
robi
------------------------------------------------------------------------
robi's Profile:
http://www.excelforum.com/member.php...o&userid=24431
View this thread: http://www.excelforum.com/showthread...hreadid=546329

Robi:

Try this:

=SUMPRODUCT(($A$1:$A$7={"Rural Town","CBD"})*B1:B7)

That formula sums the Col_B values where the Col_A value is either
"Rural Town" or "CBD".

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=546329

Cheers they all worked well.


--
robi
------------------------------------------------------------------------
robi's Profile: http://www.excelforum.com/member.php...o&userid=24431
View this thread: http://www.excelforum.com/showthread...hreadid=546329