Hi,
I have the following formulae :-
=sumproduct(roundup(E7:E184,0))
In column E I have numbers either whole or decemal and wanted to perform a round up fuction so i had the total numbers, however some cells in coulmn E contain words rather than numbers and my formulae above returns #VALUE. is there away to get it to ignore cells that contain words rather the number.
Example
E7 :- 2
E8 :- 2.5
E9:- box
E10:- 5
E11:- 1.75
The answer im looking for is 12.
Bookmarks