Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 2nd 18, 03:31 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 6
Default cleanup if and sumif in worksheet/workbook

Good day

i have a work book that make use of if and sumif to calculate and show data to 9 different blocks of data...

would it be posible to make a if/sumif or a macro to make it easier and shorter sum than currently? at the moment the blocks only use data for the first 5 items. and i expanded the items. do not feel like editing every sumif/if calculation


http://www.home-bound.co.za/saladlabel.xlsm for the file

the 9 block are located on 'new label' and the data file on 'data sheet'

regards

phillip

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cleanup this macro please Revenue Excel Programming 3 November 12th 10 03:44 AM
Sheet Cleanup Help Please BlueAngel Excel Programming 5 April 21st 10 06:14 PM
I need to use the sumif for a workbook, not a worksheet over my head Excel Worksheet Functions 3 August 8th 06 04:10 PM
Code cleanup help peter.thompson[_63_] Excel Programming 4 January 22nd 06 04:49 AM
Code cleanup peter.thompson[_53_] Excel Programming 2 January 18th 06 06:16 AM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017