IF statement clause and SUMIF statement formula help!!!!

**djmatok** · 10-27-2015, 06:20 PM

Ok. I did the following tweak to my formula . I added the "helper" now I am getting an N/A for the sub-account that has no earnings.

**djmatok** · 10-27-2015, 06:24 PM

UPDATED File

IF(A14="Y",VLOOKUP(C14,$C$2:$D$8,2,FALSE),IF(A14="N",SUMIF($B$2:$B$8,B14,$D$2:$D$8)))

Now, how can I amend this formula to pick up the remaining earnings from the Payee account in this case account 9964 and pull it under 9963. I have alot of these scenarios on my work file.

IF statement clause and SUMIF statement formula help!!!!

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: IF statement clause and SUMIF statement formula help!!!!

Re: IF statement clause and SUMIF statement formula help!!!!

Thread Information

Users Browsing this Thread

Similar Threads

Formula - sumif statement?

[SOLVED] How do I pass a MID( statement through a IsNumber in an If, Then, Else clause?

[SOLVED] SQL Transform Statement in VBA - Using Variable in the FROM clause

[SOLVED] Formula for Income Statement in financial statement

Nested SUMIF statement or multiple SUMIF's

help with =sumif statement

[SOLVED] Help please, IF statement/SUMIF statement

Bookmarks

Bookmarks

Posting Permissions