hi everyone,
can anyone help with the attached ?
please see "suivi" sheet, cell I5.
I've explained in the comment what I'm trying to do.
many thanks in advance.
best regards,
AL
exemple1_AL.xlsx
hi everyone,
can anyone help with the attached ?
please see "suivi" sheet, cell I5.
I've explained in the comment what I'm trying to do.
many thanks in advance.
best regards,
AL
exemple1_AL.xlsx
May be:
Please Login or Register to view this content.
Quang PT
great, thanks !
AL
in suivi B5,
copy paste below
=SUM(--(IFERROR((chiffrage!$B$5:$B$9=suivi!B5)*(chiffrage!$E$5:$E$10=TRANSPOSE(ressource!$A$1:$A$5))*(chiffrage!$F$5:$F$10),0)))
then hold control and shift together and then hit enter now release all three keys and drag down
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks