| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i make a sum formula ignore #div/0! errors in the range
i have a colomn where each line has uses the formula
=IF(V4=0,SUM(E4/D4*X4),SUM(W4/V4*X4)) at the bottom i am trying to sum the answers =sum(y4:y204) but some of the lines return #div/0! because there is no data on that line. ?How do you tell the sum to exclude the #div/0! errors and sum the others to get a total???? thanks in advance -- shat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| How to make formula grow with the table | Excel Discussion (Misc queries) | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
Threaded Mode
