scottnmilton
New Member
- Joined
- Jun 12, 2002
- Messages
- 2
Example of my problem. Col A contains projected expenses. Col B contains actual expenses (numeric values and blank cells for projects not completed). I need a sumif formula to evaluate Col B and sum all rows in Col A where Col B is blank (no actual expense). I have tried something to the effect of:
=sumif(B2:B150,>'',A2:A150). I am almost positive my problem is the formatting of the criteria. Any help would be appreciated.
Scott
=sumif(B2:B150,>'',A2:A150). I am almost positive my problem is the formatting of the criteria. Any help would be appreciated.
Scott