0
Is there a way to get the product of the array with conditions to round to the 2nd decimal place before summing?
Current formula w/o rounding:
=SUMPRODUCT(timecards!$H$2:$H$48692,timecards!$K$2:$K$48692*(timecards!$A$2:$A$48692=A2)*(timecards!$B$2:$B$48692=B2)*ISNUMBER(MATCH(timecards!$J$2:$J$48692,{"OT","ADDOT"},0)))*1.5
David
Posted 2015-04-23T16:28:44.907
Reputation: 15
Which column needs to be rounded before summing? H? – Excellll – 2015-04-23T19:18:56.967
H & K are the columns that the multiplication happens. That I would like rounded before the summing takes place. – David – 2015-04-23T19:23:31.507
Visit appropriated post here: stackoverflow.com/questions/.
– mgae2m – 2017-10-29T18:57:44.547