Sumproduct Function with Other Function References

**T86157** · 07-30-2012, 03:28 PM

Could someone help me with the SUMPRODUCT function in my excel log? The function is found in cell K2

The way this is, is raw data will be entered in Columns A through G. There can be more than 2 Saws but the catch is, since this is raw data it will not necessarily be categorized or ordered. For example, Rows 2 through 5 may have Saw 1 logged but below may alternate between Saw 1 and Saw 2. So may the blades. Saw 1 may go through blades faster than Saw 2, which might mean Saw 1 is on Blade #6 by the time Saw 2 is on Blade #2. I wanted my SUMPRODUCT function to be able to sum up the hours accumulated for a blade from both Saws. When the first saw blade is worn out, "2" will be entered under Column G for the Saw, then "3" and so forth. Please let me know if you have any questions.

Regards,
Ty

**tigeravatar** · 07-30-2012, 03:33 PM

T86157,

Give this a try:

Please Login or Register  to view this content.

**CheshireCat** · 07-30-2012, 03:39 PM

Try using SUMIFS.

**T86157** · 07-30-2012, 04:47 PM

Thanks for the quick response, guys. So all it was, was using absolute references with the "$" sign that would have made it work?

The reason why I like using SUMPRODUCT is because of its versatility in the situation.

**tigeravatar** · 07-30-2012, 04:56 PM

T86157,

It wasn't the absolute references, though the formula needed those in order to avoid producing incorrect results later. The problem was the double unary on the H column when it wasn't being evaluated to a boolean. I know that sounds a little strange and it shouldn't make a difference, but for some reason it really confuses Excel.