Posted 11/4/2017 19:06 (#6345584 - in reply to #6344002) Subject: RE: sum in libre calc for one item that exists in a column
East central Iowa
Thank you that worked with a minor modification.
=IFSUM(A1:A20,"*TREASURY*",B1:B20)
Putting the * on both sides of the word treasury was necessary to find all the expenses for both county treasury and federal. Just putting in treasury found nothing and putting in United States Treasury of course only found the USA treasury.
I tried it on Excel and LibreOffice Calc so that's great.