On 16-11-2013 16:08, John Meyer wrote:
=SUMIF(D1:D14,"*Landline$",F1:F14) Will this match any text in D1 to D14 that ends with the word "Landline"?
no, because the criteria are wrong. But i dont know how to specify this the correct way, i only know a 'workaround'...
If you add cells G1..G14 with the forumula: =RIGHT(Dx;8)="Landline" (replace 'x' with the rownumber) Than this will return the sum of column F for the fields that match: =SUMIF(G1:G14,TRUE(),F1:F14) -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
