Hello!
I need to "increment" a formula across columns
In Excel 2003:
From F1010 =COUNTIF(F506:F1005,3.25)
to F1260 =COUNTIF(IV506:IV1005,3.25)
--
In Excel 2010:
From F1010 =COUNTIF(F506:F1005,3.25)
to F3916 =COUNTIF(DGZ506:DGZ1005,3.25)
How can this be done without individually editing each cell ?
Thank you!
xl2003:
$F$506:$IV$1005 is an array, and ROW($A1) specifies the column of the array and increments across the array as you copy down. ,
Please Login or Register to view this content.
Last edited by protonLeah; 08-31-2018 at 05:17 PM.
Ben Van Johnson
Try this:
Formula:
Please Login or Register to view this content.
The ROW(A6) is the column number (6=F) and will increment as you drag it down (A7=G, A8=H, etc).
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you, it works!
Much obliged! I will mark as solved as soon as I figure out how ...
Select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks