Notifications
Clear all
General Excel Questions & Answers
7
Posts
2
Users
0
Reactions
145
Views
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
there is no file attached....
Posted : 09/12/2017 3:25 am
Topic starter
attached
Posted : 09/12/2017 5:15 am
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
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
Topic starter
Thanks Clark you right...
Posted : 09/12/2017 5:48 am
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