Manually auto-filling a column by 3's

**radius1080** · 06-25-2015, 09:12 AM

My formula I am trying to use is "=IF($F$2=$F$2,SUM($W2,$W3,$W4))"...when I try to auto-fill down the column it increments by 1...so "=IF($F$2=$F$2,SUM($W3,$W4,$W5))"...."=IF($F$2=$F$2,SUM($W4,$W5,$W6))".
I need it to increment by 3's, without skipping rows. So I have a title for Y1, and Y2 is: "=IF($F$2=$F$2,SUM($W2,$W3,$W4))" Y3 should be: "=IF($F$2=$F$2,SUM($W5,$W6,$W7))" Y4: "=IF($F$2=$F$2,SUM($W8,$W9,$W10))"...etc.
I've been trying to figure this out for a while now. If anyone could help me out that would be awesome. =)

**nigelbloomy** · 06-25-2015, 09:27 AM

Does this do what you need?

Please Login or Register  to view this content.

**Glenn Kennedy** · 06-25-2015, 09:28 AM

This will do it
=IF($F$2=$F$2,SUM(OFFSET($W$2:$W$4,(ROWS($1:1)-1)*3,,,)))

However, I am lost by the first bit =if(F2=F2 When will F2 NEVER be the same as itself??

**nigelbloomy** · 06-25-2015, 09:40 AM

Thank you Glen for consolidating the formula. I didn't even notice that it could be a range instead of 3 individual cells.

Manually auto-filling a column by 3's

LinkBack

Thread Tools

Rate This Thread

Display

Manually auto-filling a column by 3's

Re: Manually auto-filling a column by 3's

Re: Manually auto-filling a column by 3's

Re: Manually auto-filling a column by 3's

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating 'Region' column and auto filling data. Please help.

auto filling info into next column

Need to override Conditional Formatting by manually filling a cell

[SOLVED] After filling in a cell -> create folder and hyperlink without manually running macros

AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions