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 Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2017, 10:14 PM
knewman knewman is offline Automatically generate formulas from just the row numbers (auto insert the column) Mac OS X Automatically generate formulas from just the row numbers (auto insert the column) Office for Mac 2011
Novice
Automatically generate formulas from just the row numbers (auto insert the column) 		 
Join Date: Apr 2011
Posts: 8
knewman is on a distinguished road
Default
Not a problem.


I have added the formula to the tab 'Summary data Panels (2)' K2:N2.

I really appreciate your help
Attached Files
File Type: xlsx Flaking data_3.xlsx (485.2 KB, 9 views)
Reply With Quote
  #2  
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,103
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
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


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 04:44 PM.

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