In an earlier post I discussed about using CONCATENATE and SUMIF to sum with two conditions. This can be done using the new SUMIFS command.
lets look at the following example, if I need to know the quantity produced by machine 9 on date 4th Jan 2011.
Use formula
=SUMIFS(H:H,F:F,DATE(2011,1,4),G:G,9)
Done.
ExpiresDefault access plus 1 year
Use SUMIFS to sum values based wootingdoublemovement on multiple criteria: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
ReplyDelete