=IF(A2="","",SUMIFS(sheet1!H:H,sheet1!P:P,A2,sheet1!E:E,B2,sheet1!F:F,C2))
The above formulae takes information from "sheet1" and returns the results in "sheet2". The results returned are fractional numbers (1.5, 113.75 etc) as this is how they are entered in "sheet1", I wish to have the results shown in "sheet2" as Intergers (whole numbers) so would like to add a roundup function to the existing formulae
Bookmarks