Forum Discussion

S_Hague's avatar
S_Hague
Copper Contributor
Nov 25, 2019
Solved

Excel formula based on Date Range

Hello   I am trying to insert a total based on two assumptions.   I have two worksheets.  One which shows a unique list of part numbers and the second worksheet that shows a list of all the part ...
Formulas and Functions
  • Abiola1's avatar
    Abiola1
    Nov 26, 2019
    Good to hear. Kindly mark as the Best Response😀.

    Thanks
S_Hague's avatar
S_Hague
Copper Contributor
Nov 26, 2019

Abiola1 Perfect 🙂 That's worked a treat.  I was going wrong with trying to use a VLOOKUP and SUMIF together

 

Many thanks

Abiola1's avatar
Abiola1
MVP
Nov 26, 2019
Good to hear. Kindly mark as the Best Response😀.

Thanks

Resources