Remember Me?

#1
June 18th 20, 08:09 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Jun 2018 Posts: 21
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
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
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
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
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
June 18th 20, 08:34 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Jun 2018 Posts: 21
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Rick Excel Discussion (Misc queries) 2 February 6th 08 07:56 AM Jay Excel Worksheet Functions 0 August 10th 06 06:22 AM wahur Excel Worksheet Functions 2 May 9th 06 02:06 PM Brian Matlack Excel Discussion (Misc queries) 7 April 18th 06 12:26 AM GregR Excel Programming 10 June 24th 05 11:57 PM

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