Hot answers tagged

1

If you need a different method you can use sumproduct like the following: =SUMPRODUCT((B3:B9="Food")*(C3:C9="Groceries")*D3:D9) Where B3:B9="Food" will give 1 if True Also C3:C9="Groceries" will give 1 if True And Sumproduct will add the products 1*1*values in 2015 To compare Index/Match vs Sumifs click Here


1

I am not sure if this gonna be helpful ! As far as I am concerned, you should first consider the driver issue cause an old versioned NIC may have impact on this, if it is the problem maybe you should upgrade it. Note that you say that the cable is not an issue, you'd better use a cable tester app in the BIOS, if it comes back with errors on the cable, your ...



Only top voted, non community-wiki answers of a minimum length are eligible