Multiply every nth cell by another column whith merged cells, THEN find column total

**tpillow** · 08-06-2009, 03:55 AM

Yeah I made that post without seeing your later post. I was in the process of editing it accordingly. That post (and the sheet) are now completely different. God willing, there's a way to cleanse column A of all the repetition, but you give the impression that there isn't, aside from hiding it using conditional formating...

**DonkeyOte** · 08-06-2009, 04:04 AM

Given your blocks repeat in an even fashion why not simply highlight A2:A8 & set Font to White then subsequently highlight A5 set font to black, copy the format of A2:A8 over the remaining rows in A ?

To sum the quantity:

=SUMPRODUCT(--(MOD(ROW(A2:A29),7)=4),A2:A29)

**tpillow** · 08-06-2009, 09:02 AM

I noticed your formula targets the bottom cell (7th) in each column A block, so I just deleted the other 6 and everything seems to work fine. I would give feedback but it's asking me to "spread the love" for awhile first...

Thanks for that, from now on I'll think twice before merging cells!