Forum

Notifications
Clear all

Blank

7 Posts
2 Users
0 Reactions
145 Views
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

Hi Mynda & All

i have attached xls please help to update non sale details in formula

 
Posted : 09/12/2017 2:54 am
(@shaowu459)
Posts: 44
Eminent Member
 

there is no file attached....

 
Posted : 09/12/2017 3:25 am
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

attached

 
Posted : 09/12/2017 5:15 am
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

Hi Clark

i have updated file, please look in and update this file.

you kind co operation is highly appreciable

 
Posted : 09/12/2017 5:43 am
(@shaowu459)
Posts: 44
Eminent Member
 

Mohamed Saliha said
attached  

E6=SUMPRODUCT((F11:F86=E4)*(E11:E86=""))

may be the answer should be 4?

 
Posted : 09/12/2017 5:44 am
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

Thanks Clark you right...

 
Posted : 09/12/2017 5:48 am
(@shaowu459)
Posts: 44
Eminent Member
 

Mohamed Saliha said
Thanks Clark you right...  

haha, I looked into it very carefully, and I can't get the answer 3 🙂

 
Posted : 09/12/2017 5:49 am
Share: