Adding values within multiply columns
I have a spreadsheet with 26 columns. In one columns A I have cost center
information. In Column B I have a A or L indicator. I want to add how many times a certain groupings of cost centers appear with "A". It could be anywhere from 1 to 7 cost centers per group. I have been using Sumproduct, but it does not work in this case for me. |
Adding values within multiply columns
Maybe a pivot table
cost center as rows column b as columns anything that shows in all rows as your data right-click in the data section and field settings are count. "Scott@CW" wrote: I have a spreadsheet with 26 columns. In one columns A I have cost center information. In Column B I have a A or L indicator. I want to add how many times a certain groupings of cost centers appear with "A". It could be anywhere from 1 to 7 cost centers per group. I have been using Sumproduct, but it does not work in this case for me. |
Adding values within multiply columns
Scott.
What do you mean by I have a spreadsheet with 26 columns. In one columns A I have cost center information. What information? and how are the cost centre grouped? By names? concatenated? by numbers? -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Scott@CW" wrote in message ... I have a spreadsheet with 26 columns. In one columns A I have cost center information. In Column B I have a A or L indicator. I want to add how many times a certain groupings of cost centers appear with "A". It could be anywhere from 1 to 7 cost centers per group. I have been using Sumproduct, but it does not work in this case for me. |
Adding values within multiply columns
Sorry about that here is a breakdown.Lets say column N has one of three
options (A, T, or LOA), then the column that has cost centers in it is just a 9 to 11 digit number. The groups are set on another workshhet that I need filled out. I can use Countif with AND to get a total of teh cost centers but it is when I add the condition of "A" in column N that everything gets messed up. "Sandy Mann" wrote: Scott. What do you mean by I have a spreadsheet with 26 columns. In one columns A I have cost center information. What information? and how are the cost centre grouped? By names? concatenated? by numbers? -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Scott@CW" wrote in message ... I have a spreadsheet with 26 columns. In one columns A I have cost center information. In Column B I have a A or L indicator. I want to add how many times a certain groupings of cost centers appear with "A". It could be anywhere from 1 to 7 cost centers per group. I have been using Sumproduct, but it does not work in this case for me. |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com