Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum values according to category (text)
I wish to sum cells in a column according to category in an adjacent
column |
#2
|
|||
|
|||
=SUMIF(A:A,"value",B:B)
-- HTH RP (remove nothere from the email address if mailing direct) "Oscar" wrote in message ups.com... I wish to sum cells in a column according to category in an adjacent column |
#3
|
|||
|
|||
Thanks Bob but can I now drop into columns according to other
categories? In columns X to AC I am adding values from column G according to category with reference to column D. That part is OK I think, but then I want to further drop these totals according to category held in row 3 T to AB with reference to the drop down list in column O. If I get the principle right I can then make it more user friendly. Can anyone help? What am I doing wrong in cell Z8 which returns "#value"? |
#4
|
|||
|
|||
Oscar,
Are you saying that you now want to make the sum dependent on two conditions? I think it might help if you gave some example data, and required results. -- HTH RP (remove nothere from the email address if mailing direct) "Oscar" wrote in message ups.com... Thanks Bob but can I now drop into columns according to other categories? In columns X to AC I am adding values from column G according to category with reference to column D. That part is OK I think, but then I want to further drop these totals according to category held in row 3 T to AB with reference to the drop down list in column O. If I get the principle right I can then make it more user friendly. Can anyone help? What am I doing wrong in cell Z8 which returns "#value"? |
#5
|
|||
|
|||
Yes I am Bob, but I do not know how to attach a sample spredsheet of
what I am trying to do. Appologies for my ignorance. I include the contents of my text box. Thanks for your interest.:- In columns X to AC I am adding values from column G according to category with reference to column D. That part is OK I think, but then I want to further drop these totals according to category held in row 3 T to AB with reference to the drop down list in column O. If I get the principle right I can then make it more user friendly. Can anyone help? What am I doing wrong in cell Z8? |
#6
|
|||
|
|||
Oscar,
That is the same as you used previous post. Why don't you mail me the spreadsheet and I'll see if I can help then. -- HTH RP (remove nothere from the email address if mailing direct) "Oscar" wrote in message oups.com... Yes I am Bob, but I do not know how to attach a sample spredsheet of what I am trying to do. Appologies for my ignorance. I include the contents of my text box. Thanks for your interest.:- In columns X to AC I am adding values from column G according to category with reference to column D. That part is OK I think, but then I want to further drop these totals according to category held in row 3 T to AB with reference to the drop down list in column O. If I get the principle right I can then make it more user friendly. Can anyone help? What am I doing wrong in cell Z8? |
#7
|
|||
|
|||
Bob Phillips wrote: =SUMIF(A:A,"value",B:B) -- HTH RP (remove nothere from the email address if mailing direct) "Oscar" wrote in message ups.com... I wish to sum cells in a column according to category in an adjacent column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine "category labels" & "values" in legend | Excel Discussion (Misc queries) | |||
Can Comments be automatically converted to text cell values? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
text and values combined in one cel | Excel Discussion (Misc queries) |