Sep 05 2021 02:22 AM
Hi, everyone.
I need some help with the redesign of my sales report sheet. I work in an optical sales shop and in calculating some sales of products we offer to our clients from the daily sales records I can compute the weekly sales for each item and get excel to give me the month overview and the weekly sales overview.
Now for me to get to sum the frame sold, I had to type always FRAME: ******* before the specific name of the frame. Now I felt I could custom the frame cell to autofill FRAME via custom format "FRAME:"@ which worked, but now the SUMIFS function I used to calculate the revenue is not computing. any suggestive help cause I feel it is the last part of the formula that I need help with: =SUMIFS($H$4:$H$204,$A$4:$A$204,">="&BA209,$A$4:$A$204,"<="&BB209,$G$4:$G$204,$AQ$212 &"*")
Sep 05 2021 03:09 AM
Please attach a sample workbook (without sensitive information).
Sep 05 2021 03:29 AM
The section where the problem is located is in Row 206 (charts and Tables Analysis) and also in Column AQ to AW.
Thanks for the assist.
Sep 05 2021 04:05 AM
SolutionSep 05 2021 05:01 AM
Sep 05 2021 04:05 AM
SolutionUse
=SUMIFS($H$4:$H$204,$A$4:$A$204,">="&BA209,$A$4:$A$204,"<="&BB209,$G$4:$G$204,"*")