Ask Your Question

Sum values in one column based on criteria in another [closed]

asked 2017-05-28 15:28:27 +0100

barnmichael gravatar image

updated 2020-07-28 14:07:36 +0100

Alex Kemp gravatar image

I have a spreadsheet with column A (A8:A30) containing names and column D (D8:D30) containing points. Column E (E8:E30) is annotated with a sequence number when each name is contacted. Not all names will be contacted in a given session. I want the formula to determine if a contact number was placed in column E, then sum the points for each name contacted in cell D32. I also need the total number of contacts (not the sum of the sequence numbers) from column E(E8:E30) counted into cell D33. The end result will give the total number of contacts and the points earned for that session.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by barnmichael
close date 2017-05-31 17:11:28.341294


use VBS to achieve this.

plgeek gravatar imageplgeek ( 2017-05-29 12:58:43 +0100 )edit

Please forgive my ignorance, VBS? Vacation Bible School? I don't find any VBS in the Formula Wizard or other calc function. Is this an add-on to LibreOffice or some other Linux program?

barnmichael gravatar imagebarnmichael ( 2017-05-29 13:18:15 +0100 )edit

VBS = VBScript = Visual Basic Script

Sanjay Prasad gravatar imageSanjay Prasad ( 2018-02-16 19:10:13 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-05-31 17:09:41 +0100

barnmichael gravatar image

Finally found it. Thanks to another forum, I was pointed to which described the SUMIFS function. The formula I was looking for turned out to be: =SUMIFS(D8:D30,E8:E30,">0")

Hope this helps somebody out with a similar issue.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-05-28 15:28:27 +0100

Seen: 6,811 times

Last updated: May 31 '17