calling all friends of belfast

belfast

New Member
Joined
Sep 11, 2002
Messages
15
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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

New Poster

New Member
Joined
Aug 22, 2002
Messages
22
I don't think there are any mind readers on this forum, so it might be better if you describe the problem.
 

belfast

New Member
Joined
Sep 11, 2002
Messages
15
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,669
Members
412,481
Latest member
nhantam
Top