![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
=sumproduct(--(mod(row($f$12:$f$42),3)=0),$f$12:$f$42)
|
#3
|
|||
|
|||
![]()
Hi XOR,
I appreciate your answer. It works well for my application. Many thanks again |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
sandsoppa | Word | 2 | 10-07-2010 05:53 PM |
![]() |
techexpressinc | Word | 1 | 09-29-2009 11:36 AM |