Excel formula calculate a reorder on how much you sold when you had stock

Question

Creator

Topic
January 29, 2016 at 3:29 pm #2340862

Excel formula calculate a reorder on how much you sold when you had stock

Locked

by shalom3 · about 6 years, 12 months ago

Tags: Windows

Hi,

Till now when i wanted to know how much i sold in 3 months i pulled a report on how much got sold in the last 3 months but the problem i had was if the item was out of stock for 60 days and i pulled the report for 3 months it told me for example you sold 500pcs when really i sold this amount in only 30 days because it was out of stock for the rest of the time.

So i’m looking for a excel formula that i can ask how much got sold in the last 90 days and it only counts the days the item was in stock.

Thanks, Sol

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- January 29, 2016 at 3:29 pm #3038279
  
  Clarifications 1454081346
  
  by shalom3 · about 6 years, 12 months ago
  
  In reply to Excel formula calculate a reorder on how much you sold when you had stock
  
  Clarification dummy post @ 1454081346
Author

Replies

Viewing 0 reply threads

Start or Search

Start New Discussion

This policy describes guidelines your organization can follow to track, process and decommission IT equipment. From the policy: SUMMARY An organization’s IT hardware inventory constitutes a significant capital investment in order to perform company operations. Because hardware represents a critical asset and often holds organizational data, it is important for the company to track each ...

Whether an infection is the result of a disgruntled employee, hardware vulnerability, software-based threat, social engineering penetration, robotic attack or human error, all organizations must be prepared to immediately respond effectively to such an issue if the corresponding damage is to be minimized. Because even the best protected networks become infected, all organizations must have ...

Every operating system should be appropriately secured, especially end user workstations which often contain or permit access to company data and upon which most employee job duties are based. To get the maximum security protection out of your Windows 10 deployments follow this checklist from TechRepublic Premium. Also included in this checklist: Security solutions Product ...

Windows

Question

Excel formula calculate a reorder on how much you sold when you had stock

All Answers

Clarifications 1454081346

Hardware inventory policy

Malware response checklist

Checklist: Securing Windows 10 systems

Cloud data storage policy