1. ## Nested IF's ?

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.

=IF(A1="B",SUMIFS(C5:C200,B5:B200,4),0)

3. Thanks for that. I will give it a try and get back.

4. Fluff, your formula has solved my problem. I didn't know the SUMIFS function existed until today so thanks for the info.

D.

5. Glad to help & thanks for the feedback.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•