# Copying doesn't work!

1. ## Copying doesn't work!

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?

2. ## Re: Copying doesn't work!

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

3. ## Re: Copying doesn't work!

Thanks a lot!

4. ## Re: Copying doesn't work!

i had a rethink and can shorten that even more
Formula:

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1