Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Automatically generate formulas from just the row numbers (auto insert the column)
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 04-25-2017, 04:37 AM
xor xor is offline Automatically generate formulas from just the row numbers (auto insert the column) Windows 10 Automatically generate formulas from just the row numbers (auto insert the column) Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You will have to use SUMPRODUCT instead of COUNTIF.

See the attached.

Are you aware that you can avoid error messages like the one in L5 by using a formula like:

=IFERROR(2/J5,"") or =IFERROR(2/J5,0)
Attached Files
File Type: xlsx Flaking data_4.xlsx (424.8 KB, 11 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically insert a line after a Column Break YooperNC Word 3 01-29-2015 07:16 AM
Auto Generate Invoice Number Word 2013 Jonah245 Word VBA 3 09-04-2014 05:24 PM
Automatically generate formulas from just the row numbers (auto insert the column) Automatically generate PDF from saved word doc JamesHusband Word 3 06-07-2014 08:30 AM
Randomly generate numbers, Macro? Jamtart PowerPoint 30 08-15-2012 10:55 AM
Can I auto increase numbers in a column? compact Word 1 09-10-2009 07:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft