Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi Saliha,
Your question isn't clear, sorry. First, I'm not sure what cells contain the manual calculation you wish to automate. Second, I can't see how the Qty figures in cells B21:B26 are derived. Third, I don't know what the calculation is that you're wanting to automate.
Mynda
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi Saliha,
Thanks for providing a clear example.
Excel can't easily count based on a cell colour. You're best to put the size data in an adjacent cell so you can use the COUNTIF function. If you can't do that then you'll need to use VBA to count cells based on colours.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kristi Downer, Andrea Fernandez-Trujillo, christine kyakumpi
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 289
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Richard Gower
Sanket Rathod
Tung Vo
chutima thongnan
David Ball
Ali Asghar
Forum Stats:
Groups: 3
Forums: 24
Topics: 6876
Posts: 30139
Member Stats:
Guest Posters: 49
Members: 33693
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —