Forum Discussion

EFEANA NOUR's avatar
EFEANA NOUR
Copper Contributor
Nov 13, 2017

SUMIF Function for a period between two dates

Kindly open the attached Excel Sheet first to fully understand me

Hi guys, Please i need to calculate the ( Roll Quantity, Total Amounts )for each buyer according to a specific month.

 

In the Excel Workbook you can find 2 Sheets :

1- Yearly Selling.

2- JAN (January)

 

I need Excel to calculate for example:

 

For John Roll Quantity and Total Amount through JAN only and then for the rest of buyers accordingly.

 

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Nov 13, 2017

    Hi,

     

    I attached the solution for you. See the attachment.

    But please note that the roll quantity and total amount for each buyer is the same,

    Because each of them has one record in a month.

     

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 13, 2017

    Hi,

     

    I attached the solution for you. See the attachment.

    But please note that the roll quantity and total amount for each buyer is the same,

    Because each of them has one record in a month.

     

    • EFEANA NOUR's avatar
      EFEANA NOUR
      Copper Contributor
      Nov 14, 2017

      OMG!!!!!!

       

      Thanks Thanks Thanks

       

      you helped me to finish a work that would take from me a plenty of time.

       

      Thanks bro

Resources