Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
totaling rows
New at this hope this makes sense:
I have rows of data that include entering demographics, 6 columns indicate race, 2 columns gender, six age range columns and a total participant column. What formula would add the numbers in each of the demographics and insure that the different ranges equal each other and the total participants for each row. Thanks, Mel |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
totaling rows
"Mel" wrote: New at this hope this makes sense: I have rows of data that include entering demographics, 6 columns indicate race, 2 columns gender, six age range columns and a total participant column. What formula would add the numbers in each of the demographics and insure that the different ranges equal each other and the total participants for each row. ie. col. I J K L M N O P Q R S T U V WB AOHU Male Female <5 5-12 13-18 19-49 50-64 65+ Total row 55 4 27 28 59 59 It would let the person know the Gender doesn't equal the other totals. Mel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
totaling rows
Taken separately,
=SUM(I2:N2) gives the total of the race columns, =O2+P2 gives the total of the gender columns, =SUM(Q2:V2) gives the total of the age columns, assuming your data is on row 2. So, depending on what you want to highlight, you can put these together in an IF formula, eg: =IF(SUM(I2:N2)<O2+P2,"Gender/Race difference",IF(SUM(Q2:V2)<SUM(I2:N2),"Age/Race difference",IF(O2+P2<SUM(Q2:V2),"Gender/Age difference","Totals agree"))) Is this the kind of thing you want? Obviously, Excel can't tell you which is correct, just point out that there is a difference. Hope this helps. Pete On Jul 24, 4:36 pm, Mel wrote: "Mel" wrote: New at this hope this makes sense: I have rows of data that include entering demographics, 6 columns indicate race, 2 columns gender, six age range columns and a total participant column. What formula would add the numbers in each of the demographics and insure that the different ranges equal each other and the total participants for each row. ie. col. I J K L M N O P Q R S T U V WB AOHU Male Female <5 5-12 13-18 19-49 50-64 65+ Total row 55 4 27 28 59 59 It would let the person know the Gender doesn't equal the other totals. Mel - Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
totaling rows
Thank you so much, took the formula you wrote and add another IF statement to
include the total. Prefect just what I wanted. Thanks again. "Pete_UK" wrote: Taken separately, =SUM(I2:N2) gives the total of the race columns, =O2+P2 gives the total of the gender columns, =SUM(Q2:V2) gives the total of the age columns, assuming your data is on row 2. So, depending on what you want to highlight, you can put these together in an IF formula, eg: =IF(SUM(I2:N2)<O2+P2,"Gender/Race difference",IF(SUM(Q2:V2)<SUM(I2:N2),"Age/Race difference",IF(O2+P2<SUM(Q2:V2),"Gender/Age difference","Totals agree"))) Is this the kind of thing you want? Obviously, Excel can't tell you which is correct, just point out that there is a difference. Hope this helps. Pete On Jul 24, 4:36 pm, Mel wrote: "Mel" wrote: New at this hope this makes sense: I have rows of data that include entering demographics, 6 columns indicate race, 2 columns gender, six age range columns and a total participant column. What formula would add the numbers in each of the demographics and insure that the different ranges equal each other and the total participants for each row. ie. col. I J K L M N O P Q R S T U V WB AOHU Male Female <5 5-12 13-18 19-49 50-64 65+ Total row 55 4 27 28 59 59 It would let the person know the Gender doesn't equal the other totals. Mel - Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
totaling rows
Thanks for feeding back, Mel - glad it worked for you.
Pete On Jul 25, 3:36 pm, Mel wrote: Thank you so much, took the formula you wrote and add another IF statement to include the total. Prefect just what I wanted. Thanks again. "Pete_UK" wrote: Taken separately, =SUM(I2:N2) gives the total of the race columns, =O2+P2 gives the total of the gender columns, =SUM(Q2:V2) gives the total of the age columns, assuming your data is on row 2. So, depending on what you want to highlight, you can put these together in an IF formula, eg: =IF(SUM(I2:N2)<O2+P2,"Gender/Race difference",IF(SUM(Q2:V2)<SUM(I2:N2),"Age/Race difference",IF(O2+P2<SUM(Q2:V2),"Gender/Age difference","Totals agree"))) Is this the kind of thing you want? Obviously, Excel can't tell you which is correct, just point out that there is a difference. Hope this helps. Pete On Jul 24, 4:36 pm, Mel wrote: "Mel" wrote: New at this hope this makes sense: I have rows of data that include entering demographics, 6 columns indicate race, 2 columns gender, six age range columns and a total participant column. What formula would add the numbers in each of the demographics and insure that the different ranges equal each other and the total participants for each row. ie. col. I J K L M N O P Q R S T U V WB AOHU Male Female <5 5-12 13-18 19-49 50-64 65+ Total row 55 4 27 28 59 59 It would let the person know the Gender doesn't equal the other totals. Mel - Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-Totaling | Excel Discussion (Misc queries) | |||
Sub-Totaling | Excel Worksheet Functions | |||
totaling to a different sheet | Excel Discussion (Misc queries) | |||
Totaling Each Page | Excel Discussion (Misc queries) | |||
Totaling rows of text | Excel Worksheet Functions |