Skyshadow5
Technical User
I need some help please.
I'm using Excel 2003 to return some values from a large spreadsheet. The values need to be summed but only if matching 2 criteria. Column 1 holds a company name (there are 5 different names), column O holds the value. I need the sum of values where column 1 matches 1 of the company names and the value in column O is between 0 & 200. I need to repeat the formula in the adjacent cell but this time with the same company name and the value this time between 201 & 400.
I've tried to include a small sample of the data as an example.
I have seen other answers to multiple criteria questions but they are all text based criteria whereas my second criteria is a value between a specified range which makes it, for me at least, a little more difficult to suss out. Appreciate the help.
Clive
I'm using Excel 2003 to return some values from a large spreadsheet. The values need to be summed but only if matching 2 criteria. Column 1 holds a company name (there are 5 different names), column O holds the value. I need the sum of values where column 1 matches 1 of the company names and the value in column O is between 0 & 200. I need to repeat the formula in the adjacent cell but this time with the same company name and the value this time between 201 & 400.
I've tried to include a small sample of the data as an example.
I have seen other answers to multiple criteria questions but they are all text based criteria whereas my second criteria is a value between a specified range which makes it, for me at least, a little more difficult to suss out. Appreciate the help.
Clive