Nested IF's ?

Dougj

New member
Joined
Oct 29, 2018
Messages
21
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.
 
How about
=IF(A1="B",SUMIFS(C5:C200,B5:B200,4),0)
 
Thanks for that. I will give it a try and get back.
 
Fluff, your formula has solved my problem. I didn't know the SUMIFS function existed until today so thanks for the info.

D.
 
Glad to help & thanks for the feedback.
 
Back
Top