Totalling values across columns
 

Hi all,
I have 2 columns A1:A600 & C1:C600
Column "A" contains a number of 'Validated List' drop boxes and Column "C"
contains values that depend on the list box selection
Q: If various boxes contained say "Carpenter" - How do I total the
resultant values of these from Column "C" to show the total value of all
"Carpenter" boxes??
Help

Try this:

=SUMIF(A1:A600,"Carpenter",C1:C600)

You could also enter the item to add into a particular cell, so that it
would be easily changed:

=SUMIF(A1:A600,D1,C1:C600)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Glenn" wrote in message
...
Hi all,
I have 2 columns A1:A600 & C1:C600
Column "A" contains a number of 'Validated List' drop boxes and Column "C"
contains values that depend on the list box selection
Q: If various boxes contained say "Carpenter" - How do I total the
resultant values of these from Column "C" to show the total value of all
"Carpenter" boxes??
Help

=SUMIF(A1:A600, "Carpenter", C1:C600)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Glenn" wrote in message
...
Hi all,
I have 2 columns A1:A600 & C1:C600
Column "A" contains a number of 'Validated List' drop boxes and Column "C"
contains values that depend on the list box selection
Q: If various boxes contained say "Carpenter" - How do I total the
resultant values of these from Column "C" to show the total value of all
"Carpenter" boxes??
Help

One way to set it up

Copy the DV from any cell in col A
into say, E1:H1

Put in E2: =IF(E1="","",SUMIF($A:$A,E1,$C:$C))
Copy E2 across to H2

E2:H2 will return the sums of the DV items selected in E1:H1
from col C

Example: If you select from the DV in E1: "Carpenter"
E2 wil return the corresponding total from col C
where col A = "Carpenter"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Glenn" wrote in message
...
Hi all,
I have 2 columns A1:A600 & C1:C600
Column "A" contains a number of 'Validated List' drop boxes and Column "C"
contains values that depend on the list box selection
Q: If various boxes contained say "Carpenter" - How do I total the
resultant values of these from Column "C" to show the total value of all
"Carpenter" boxes??
Help