hi everyone!
i need to sum 4 cells in columns A-D...some of the cells have an error [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! which I want the formula to ignore.
Take Row 5 in table 1 below for examples: Cell A5 and B5 have numbers, but cell C5 and D5 have an erroe...i want cell E5 to only total the cells with numbers.
If ALL 4 cells contain [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! (SEE ROW 6) I would like the column E to display a blank cell.
TABLE 1
<tbody>
</tbody>
i need to sum 4 cells in columns A-D...some of the cells have an error [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! which I want the formula to ignore.
Take Row 5 in table 1 below for examples: Cell A5 and B5 have numbers, but cell C5 and D5 have an erroe...i want cell E5 to only total the cells with numbers.
If ALL 4 cells contain [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! (SEE ROW 6) I would like the column E to display a blank cell.
TABLE 1
A | B | C | D | E | |
1 | Q1 GROWTH IN LEVELS | Q2 GROWTH IN LEVELS | Q3 GROWTH IN LEVELS | Q4 GROWTH IN LEVELS | ANNUAL GROWTH IN LEVELS |
2 | 0 | 1 | 1 | 1 | 3 |
3 | 0 | 1 | 2 | 2 | 5 |
4 | 0 | 0 | 0 | 0 | 0 |
5 | 0 | 1 | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! | 1 |
6 | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=value]#value [/URL] ! |
<tbody>
</tbody>