Whoever sent it to you needs to goto an Excel class.
Goto sheet1select the col b HEADERf5specialblanksOKentirerowthen
touch the delete key

Sub ClearBlanks()' this macro does the above
Columns("B"). _
SpecialCells(xlCellTypeBlanks). _
EntireRow.Delete
End Sub
then put this.ONE line in cell f5
=SUMPRODUCT((Sheet1!$A$3:$A$154=B5)*(Sheet1!$B$3:$ B$154=C5)*(Sheet1!$C$3:$C$154=TEXT(D5,"###"))*Shee t1!$H$3:$H$154)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"willemeulen" wrote in message
...

That is how I get the stuff from the net, how can I change that?
Material prices are split in classes on internet and give a header row
each time, luckily hiding the rows does not affect the refreshing of
data, how do I need to solve this, would unhiding rows help?


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile:
http://www.thecodecage.com/forumz/member.php?userid=285
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=105263