Avatar of Pau Lo
Pau Lo

asked on 

SUMIF assistance

I have got a worksheet full of data (around 2000 rows and 15 columns). I need to do a sumif to see how often in the data, 2 columns match, to see how many rows have those same 2 values in these 2 columns (reference and address line 1). Can anyone provide any pointers, say for example column A is my "count" column, where I will be applying the SUMIF calculation to get a count, and column B is the reference column, and column C is the address line 1 column.

e.g.
count-reference-address1
---------------------------------------
2-12345-1 EE street
2-12345-1 EE street
1-34567-2 EE street
Microsoft Excel

Avatar of undefined
Last Comment
Koen
SOLUTION
Avatar of Koen
Koen
Flag of Belgium image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Koen
Koen
Flag of Belgium image

if you import the data (or append) regulary then turn the import into a table (select a cell within the data an click 'Insert', 'Table').Then create both columns (with the formulas) at the right end.
The table will auto adjust and when you import the next time (and there are more or less lines) the formulas will adjust automatically.
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Pau Lo
Pau Lo

ASKER

thanks both worked fine
Avatar of Koen
Koen
Flag of Belgium image

please assign point if you are satisfied with the solution...
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo