Hi
I was wondering if it is possible to join multiple attributes in the query editor in Excel? My raw data consists of the energy consumption on the different groups, however some of these groups are compatible and it would be beneficial to simply sum these. For example, I would like to join the group InteriorLightingI with InteriorLightingII and sum the data related to the two groups.
Are you required sum of amount "InteriorLightingI & InteriorLightingII" group?
If this correct, then use below formula.
If your group in column "A" & Amount in column "B"
Formula in "B13"
Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks