i am using the IF script, and i am also using the COUNT script in the logical part of the IF statement.
i need to make sure that both K3 and V3 have a value inside of the cell in order for the statement to work, although when just K3 has a value, the IF - TRUE statement works anyway. any ideas on how to fix this?
=IF(COUNT(K3,V3),SUM(K3+V3),"")
Last edited by o AXE; 06-14-2009 at 01:19 AM.
Hi
=IF(AND(K3>0, V3>0),SUM(K3,V3),"")
Ravi
Hi o AXE,
How about this:
Cheers,Code:=IF(AND(ISNUMBER(K3),ISNUMBER(V3)),SUM(K3+V3),"")
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
thanks a lot for the replies. they both worked but this one only kept the one row. thanks!Originally Posted by ConneXionLost
ConnexionLost, please only use Code Tags for VBA code, not formulas.
Moving this post to the correct Forum
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks