energizek
11-30-2009, 06:51 AM
Hi, I am making a budget and need to sum certain cells that contain numbers. However, if the user doesn't have an item for a certain category that cell will read "#N/A". When it comes time to get a total Excel won't sum the cells unless all of them have a numeric value. I've tried using "isnumber" and "sumif" but get an error saying that I've entered "too many arguments for the function."
Here is my code:
=If(Isnumber(AA173,Z173,Y173,W173,U173,R173,P173,J173,H173,F173), Sum(AA173,Z173,Y173,W173,U173,R173,P173,J173,H173,F173),0)
Any suggestions?
-Katie
Here is my code:
=If(Isnumber(AA173,Z173,Y173,W173,U173,R173,P173,J173,H173,F173), Sum(AA173,Z173,Y173,W173,U173,R173,P173,J173,H173,F173),0)
Any suggestions?
-Katie