I have the formule:
I need to copy this formula down, and I would like the bold numbers and letters count.=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 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?
Bookmarks