ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sumproduct but exclude labels (https://www.excelbanter.com/excel-worksheet-functions/173467-sumproduct-but-exclude-labels.html)

momto2

Sumproduct but exclude labels
 
I am using the formula below and getting a #value error. I have determined
that it is because I have header rows within the rows 5 - 28. When I remove
those, the formula returns the correct value. However, I need to have the
head rows periodically though the data. Is there a way to write the formula
to both exclude negative values and "labels" ie. text?


MROUND(SUMPRODUCT((C5:C280)*(D5:D280)*(C5:C28)*( D5:D28)*(H5:H28)),5)

Thanks


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com