What formula would write to make sure that column H (circled in the picture)has balances greater than zero in any of the rows, while leaving out the row that has been boxed in the picture.
SEE PICTURE:
Loan Chart Reference_Excel Help.png
What formula would write to make sure that column H (circled in the picture)has balances greater than zero in any of the rows, while leaving out the row that has been boxed in the picture.
SEE PICTURE:
Loan Chart Reference_Excel Help.png
Hard to say for sure without an actual file to work with (pics are pretty much useless to us), but have you tried using countifS() for this, with 1 of the criteria testing B for something like <> School
Also, please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to (you has shown the operating system). Members tailor answers based on your Excel version.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks