Forum Discussion

afiifi's avatar
afiifi
Copper Contributor
Jun 21, 2023

FORMULAR

 

 

 

please i have excel sheet 1 with 

A1               B1

..............................

RED           100

YELLOW     50

RED            80

YELLOW      20

 

 

 

I want the total value  OF  ANY OF COLOUR  in another sheet which is sheet 2

 

please kindly help me with the formular

Resources