Re: SOMME.SI de LibreOffice

Top Page
This message is part of the following thread:
Mthe complete thread tree sorted by date
MFrédéric at <-
MFrédéric at ->

Reply to this message
Author: MicheL .
Date:  
To: guilde@guilde.asso.fr
Subject: Re: SOMME.SI de LibreOffice


Le 16/09/2016 à 09:34, Frédéric a écrit :
> Hello,
bonjour
>
>    =SUMIF(Ventilation.$B$2:$B$200;"=Bilan.$A12";Ventilation.C$2:C$200)
>

=SUMIF(Ventilation.$B$2:$B$200;"="&Bilan.$A12;Ventilation.C$2:C$200)
ou dans le cas d'une égalité :
=SUMIF(Ventilation.$B$2:$B$200;Bilan.$A12;Ventilation.C$2:C$200)

MicheL

This message was posted to the following mailing lists:
Guilde
Mailing List Info | Nearby Messages		<-SOMME.SI de LibreOfficeRe: SOMME.SI de LibreOffice->
Archive des listes de la GUILDE administrated by L'administrateurLurker (version 2.3)