calling all friends of belfast

[belfast]

Both Aladin, Sen-dp and andreas had helped me to solve a problem but on looking deeper a problem has arisen when the number of columns is large and the numbers of non blank cells is quite large. I start to get #VALUE problems. Has anybody any thoughts
Belfast

 

[New Poster]

I don't think there are any mind readers on this forum, so it might be better if you describe the problem.

 

[Hero-0952]

I believe that the original posts began here:
http://www.mrexcel.com/board/viewtopic.php?topic=21920&forum=2&21

Regards,

ViperGTS
This message was edited by ViperGTS on 2002-09-12 21:11

 

[belfast]

I have a set of data of around 100 rows with column headings in row 1. The column headings may be the same eg a, b, c, a, a , c. In the cells below each column header there are many blan cells and some numbers, randomly distributed. At the extreme right I have a column which sums the numbers in each row. I need a formula which sums those row totals in the right hand column whose rows contain one or more nonblank cells with a column header of 'a'.
I hope i have explained that prperly . I would appreciate any help
I had recieved two solutions, one involving SUMPRODUCT and the other using HLOOKUP. Both did exactly what I wanted except if there was a sizeable number of entries in a row #VALUE problems occured. If you search for the only other Belfast post you can find it. I should have kept that post going but having thanked everyone I thought that one was a dead duck.
Please help

 

[sen_edp]

Hello Belfast

please don't open a new thread for the same
subject

i wil reply in the old one
http://www.mrexcel.com/board/viewtopic.php?topic=21920&forum=2&21