Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2016, 11:36 AM
james64 james64 is offline I am asking some formula for electrical panel schedule Windows 10 I am asking some formula for electrical panel schedule Office 2007
Novice
I am asking some formula for electrical panel schedule
 
Join Date: Jan 2016
Posts: 2
james64 is on a distinguished road
Default I am asking some formula for electrical panel schedule

Hi everybody



I would like to ask a question.

I am working on electrical panel schedule using excel formula, but it looks like spending a lot of time tediously. So I am asking your comment how to apply some formula every other three number summation. Please see attached file for your reference. For example, I am adding sum(F12+F15+F18+..F42).

Many thanks in advance.

James
Reply With Quote
  #2  
Old 01-16-2016, 07:35 PM
xor xor is offline I am asking some formula for electrical panel schedule Windows 10 I am asking some formula for electrical panel schedule Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,100
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 Sum every third

=sumproduct(--(mod(row($f$12:$f$42),3)=0),$f$12:$f$42)
Reply With Quote
  #3  
Old 01-16-2016, 09:23 PM
james64 james64 is offline I am asking some formula for electrical panel schedule Windows 10 I am asking some formula for electrical panel schedule Office 2007
Novice
I am asking some formula for electrical panel schedule
 
Join Date: Jan 2016
Posts: 2
james64 is on a distinguished road
Default

Hi XOR,

I appreciate your answer. It works well for my application.

Many thanks again
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
I am asking some formula for electrical panel schedule Problem - 4 panel per sheet saved somehow Gurdjieff Word 1 04-05-2015 09:46 PM
any idea how to add a master dashboard or control panel that is able to tell my formu akatz85 Excel 6 03-27-2014 01:13 PM
how to collapse the page panel in onenote 2013? Delta223 OneNote 0 03-08-2013 10:24 AM
I am asking some formula for electrical panel schedule get rid of the right ad panel sandsoppa Word 2 10-07-2010 05:53 PM
I am asking some formula for electrical panel schedule Review Panel keeps poping up when i open a doc. techexpressinc Word 1 09-29-2009 11:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.


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