# Can't get Sum to work with current forumla

1. ## Can't get Sum to work with current forumla

Electrical Quote Forms.xlsx

Here is the spreadsheet, I'm trying to get a completed sum at the bottom but get n/a.

Thanks,

2. ## Re: Can't get Sum to work with current forumla

all your lines are N/A so its coming down, you need to put =if(h21<>"",h21*b21,"") i think, your sheets readonly password protected so cant see.

3. ## Re: Can't get Sum to work with current forumla

Electrical Quote Forms.xlsx
Should be unprotected

Thanks

4. ## Re: Can't get Sum to work with current forumla

Change the formula in I21 to =IF(B21="","",B21*H21) and copy down
Change the formula in I35 to =SUM(I21:I34)
Change the formula in I38 to SUM(I35:I37)

http://www.techonthenet.com/excel/formulas/if.php

Thanks Alan,

That worked!

6. ## Re: Can't get Sum to work with current forumla

Or you could just "hide" the errors.

Formula:

and

Formula:

Regards, TMS

7. ## Re: Can't get Sum to work with current forumla

or change i35 to
=IF(SUMIF(I21:I34,"<>#n/a"),SUMIF(I21:I34,"<>#n/a"),"")
and
i36 to
=IF(I35="","",I35*D18)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1