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.
use VBS to achieve this.
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?
VBS = VBScript = Visual Basic Script
Finally found it. Thanks to another forum, I was pointed to SUMIFS function - LibreOffice Help 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.
Michael