How to use SUMIFS

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.