Sumproduct but exclude labels

M

momto2

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:C28>0)*(D5:D28>0)*(C5:C28)*(D5:D28)*(H5:H28)),5)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct giving #Value error 5
Formula not working properly 2
Adding cells but leaving blank if not populated 2
Variable Sumproduct Range 6
change cell color depending on two cell values 1
Working with time calculations 3
CTRL SHIFT ENTER 2
SUMPRODUCT to exclude text column header 1

Top