Sumproductif?

[dvibe]

Hello,

I am trying to create a sumproduct for ColumnD*ColumnE if there is a value in columnG. The value in Column G will be a number 1-31 that will NOT be included in the sum product. Any ideas?

Thank you

 

[ron_at_buy]

Given the information in your question, try:

=SUMPRODUCT(--(G2:G9>0),D29*E2:E9)

Change range to suit your data
Hope this helps

=SUMPRODUCT(--(G2:G9>0),D29*E2:E9)

This is stupid - whats wrong can't get rid of that ridiculous face should be:
D29*E2:E9

CLEARLY THERE IS A BUG!!!!!!!!!!!!!!!!!!!!!!

D 2 : D 9*E2:E9

Without the spaces!!