Copying doesn't work!

**jordiadhd** · 08-06-2014, 10:57 AM

I have the formule:

=IF(ISNUMBER($Q42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($R42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($S42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($T42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($U42);SUM('Opslag grafiek'!C$113:C$268);IF(ISNUMBER($V42);SUM('Opslag grafiek'!C$125:C$172);0))))))

I need to copy this formula down, and I would like the bold numbers and letters count.
i want the C in the next box become a D and 42 become 43.
I only get the 42 to 43 but the C wont go to D.

Is there a way to do this?

**martindwilson** · 08-06-2014, 06:55 PM

you can shorten that a bit then
IF(COUNT($Q42:$U42);SUM(INDEX('Opslag grafiek'!$C:$XFD;113;ROWS($1:1)):INDEX('Opslag grafiek'!$C:$XFD;268;ROWS($1:1)));IF(ISNUMBER($V42);SUM(INDEX($C:$XFD;125;ROWS($1:1)):INDEX($C:$XFD;172;ROWS($1:1)));0))
should work

**jordiadhd** · 08-07-2014, 02:50 AM

Thanks a lot!

**martindwilson** · 08-07-2014, 03:54 AM

i had a rethink and can shorten that even more

Formula:

Please Login or Register  to view this content.

i also noticed i missed the sheet references in the second part of the previous post

Copying doesn't work!

LinkBack

Thread Tools

Rate This Thread

Display

Copying doesn't work!

Re: Copying doesn't work!

Re: Copying doesn't work!

Re: Copying doesn't work!

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copying filtered table doesn't work as it is expected in Excel 2010

[SOLVED] Macro work in personal workbook, doesn't work in other workbooks

[SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option

Copying a webpage - it doesn´t work as just fractions get copied

Copying and pasting formulas doesn't work!!

Bookmarks

Bookmarks

Posting Permissions