Hi. I really need some help with a formula.
I have a large data set which has numerous columns and rows of information in blocks of 4 rows (starting at row 7) . Every 2nd row within the block has text inputs and the 1st row contains values. I would like to put a formula in each column (if possible above row 7) which checks every 2nd rows and then adds any values in the cells above if the text matches.
If this is possible within a formula then I would be very grateful for someone's help.
Thanks
James
Bookmarks