Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 18th 20, 08:09 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 21
Default not sure but think sumif problem

i have column E with downwards multiple entrys of wich some is repetetive in other words
e13 a
e14 b
e15 a
e16 c
e17 a
e18 b
e19 a
e20 c
e21 a
e22 b

and in g i have amounts thats corresponding/refering to E for example
g13 100
g14 101
g15 204
g16 20
g17 50
g18 10
g19 100
g20 101
g21 30
g22 47

i need in column L to only show

L13 a
L14 b
L15 c

and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example

M13 484
M14 158
M15 121

there will be on different sheets different amounts of rows so it could be on one sheet 23 unique items in column E and on another sheet 100 unique items

thank you!!!

can send sample of the workbook

  #2   Report Post  
Old June 18th 20, 08:15 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,802
Default not sure but think sumif problem

Hi Phillip,

Am Thu, 18 Jun 2020 12:09:00 -0700 (PDT) schrieb Phillip Swanepoel:

i have column E with downwards multiple entrys of wich some is repetetive in other words
e13 a
e14 b
e15 a
e16 c
e17 a
e18 b
e19 a
e20 c
e21 a
e22 b

and in g i have amounts thats corresponding/refering to E for example
g13 100
g14 101
g15 204
g16 20
g17 50
g18 10
g19 100
g20 101
g21 30
g22 47

i need in column L to only show

L13 a
L14 b
L15 c

and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example

M13 484
M14 158
M15 121


in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old June 18th 20, 08:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,802
Default not sure but think sumif problem

Hi again,

Am Thu, 18 Jun 2020 21:15:44 +0200 schrieb Claus Busch:

in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down


sorry, typo!
=SUMIF($D$13:$D$22,L13,$G$13:$G$22)


Regards
Claus B.
--
Windows10
Office 2016
  #4   Report Post  
Old June 18th 20, 08:34 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 21
Default not sure but think sumif problem

Thank you Claus

just note that column L is empty. the data from E stil needs to be 'send' to L

I see you used D(should be E)

i have like the following now

first i will need to get L filled with all the unique values from E

then in M need to do a sum of all the uniques corresponding amounts


On Thursday, June 18, 2020 at 9:17:23 PM UTC+2, Claus Busch wrote:
Hi again,

Am Thu, 18 Jun 2020 21:15:44 +0200 schrieb Claus Busch:

in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down


sorry, typo!
=SUMIF($D$13:$D$22,L13,$G$13:$G$22)


Regards
Claus B.
--
Windows10
Office 2016




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
sumif problem Rick Excel Discussion (Misc queries) 2 February 6th 08 07:56 AM
Sumif Problem Jay Excel Worksheet Functions 0 August 10th 06 06:22 AM
SUMIF problem wahur Excel Worksheet Functions 2 May 9th 06 02:06 PM
SumIf Problem Brian Matlack Excel Discussion (Misc queries) 7 April 18th 06 12:26 AM
Sumif problem GregR Excel Programming 10 June 24th 05 11:57 PM


All times are GMT +1. The time now is 03:42 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017