Add Roundup to existing formulae/

=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

If all are rounded up:
=IF(B104="","",SUMPRODUCT(ROUNDUP($F$7:$F$100,0)*($B$7:$B$100=$B104)*($E$7:$E$100=C104)))

If all are rounded to nearest integer only:
=IF(B104="","",SUMPRODUCT(ROUND($F$7:$F$100,0)*($B$7:$B$100=$B104)*($E$7:$E$100=C104)))

You can use a helper column to round the numbers and sum on this column.

Originally Posted by Dom.Knight

Just seems to return #value

It seems there are text string inside column, try IFERROR to eliminate. Post a sample worksheet.

Column F have "" (null value) coming from formula.

Try again:

=IF(B104="","",SUMPRODUCT(ROUNDUP($F$7:$F$100&0,0)*($B$7:$B$100=$B104)*($E$7:$E$100=C104)))

You just said that it does not work, but did not tell us what the error is.
Try to post a screenshot or worksheet again with errors.

OK. Try again:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).