Dougj
New member
- Joined
- Oct 29, 2018
- Messages
- 22
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2007 office365
Good day folks.
I am having a bit of trouble with a formula, most specifically where I need to specify ranges.
Here is what I am trying to do.
Cell A1 can contain one of two entries, either an "A" or "B".
Cells in Column B (range of about B5:B200) can contain either a "1","2", "3" or "4".
If cell A1 contains an "A" then I simply want to enter a $0.00 in cell C1.
If, however, cell A1 contains a "B" then in cell C1 I want to SUM all the cells in column C (range of about C5:C200) that have a corresponding cell in Column B that contains a "4".
I think I should be using nested IF's or SUMIF's but I am having difficulty specifying how to add all the values in column C based on what is in column C.
Any direction would be appreciated.
D.
I am having a bit of trouble with a formula, most specifically where I need to specify ranges.
Here is what I am trying to do.
Cell A1 can contain one of two entries, either an "A" or "B".
Cells in Column B (range of about B5:B200) can contain either a "1","2", "3" or "4".
If cell A1 contains an "A" then I simply want to enter a $0.00 in cell C1.
If, however, cell A1 contains a "B" then in cell C1 I want to SUM all the cells in column C (range of about C5:C200) that have a corresponding cell in Column B that contains a "4".
I think I should be using nested IF's or SUMIF's but I am having difficulty specifying how to add all the values in column C based on what is in column C.
Any direction would be appreciated.
D.