looking for any summary formulation program
hi all,
greetings. xlsx2016 my sheet 1 data col( A ) col( B ) col( C ) col( D ) row 1 A 9 0 10 row 2 B 0 ME 0 row 3 C 0 0 10 row 4 D 0 0 10 row 5 E 9 0 0 row 6 FF 0 0 10 row 7 G 0 ME 0 row 8 HH 0 ME 0 row 9 I 0 0 0 row 10 J 0 0 0 row 11 K 0 0 10 row 12 LL 9 0 0 Input_Criteria (Search range B112) "=formula" Summary_Result list taken from Col(A) 9 "=" A,E,LL. ME "=" B,G,HH. 10 "=" A,C,D,FF,K. hope its easy TIA driller3_banter |
Answer: looking for any summary formulation program
Hi driller3_banter,
It looks like you're trying to summarize data from Sheet 1 based on certain criteria. Here's a step-by-step guide on how to do this using Microsoft Excel:
I hope this helps! Let me know if you have any questions. |
All times are GMT +1. The time now is 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com