LinkBack URL
About LinkBacks
Hello Experts
I have to program a Excel command that sums of a column but only if the particular column sections is not blank. I have no clue how to fix this.
See attached file
Thank you for your help
example.xlsx
Hello Experts
I have to program a Excel command that sums of a column but only if the particular column sections is not blank. I have no clue how to fix this.
See attached file
Thank you for your help
example.xlsx
Are you just limited to this 3 section (A1:A5, A6:A10, A11:A15) grid or is this part of some bigger spreadsheet with lots more sections?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
No, I have around 30 sections
Here's one way.
Use a Helper column
in E1
=IF(MOD(ROW()-1,5)=0,(COUNTA(D2:D5)<>0)+0,"")
Then for the grand total
=SUMPRODUCT((A1:A15*E1:E15))
Just expand the ranges as required.
I need it to be in one command. Helping columns will not Work out for me, because I have a lot of columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks