Need to find the Total value of daily sales on Monday, Tuesday, etc.

Also need to find % of grand total sales depending on the day of the week

and the rank of those sales depending on the weekday

You can use the rest of this worksheet to calculate these values. You will need to use the WEEKDAYO and IFO functions to break-out the data needed for this portion. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline A & B & c & D & E & F & G & H & I & \\ \hline 1 & & \multicolumn{8}{|c|}{ DAILY SALES } \\ \hline? & DATE & STOREPA-04 & STOREPA-09 & STORENJ-02 & STOREPA-12 & STOREDE-07 & STORENJ08 & STOREDE-01 & STOREPA-03 \\ \hline 3 & 6/24/2022 & 517,631 & $13,717 & 519,486n & no data & $11,941 & 518,187 & $14,017 & 514,370 \\ \hline 4 & 6/25/2022 & 523,481 & 517,777 & 521,113 & 517,360 & 520,528 & \multicolumn{2}{|c|}{521,653 no data } & S15, 616 \\ \hline 5 & 6/26/2022 & 522,985 & 519,289 & 524,323 & 524,698 & 522,872 & $16,906 & 522,776 & 523,610 \\ \hline 6 & 6/27/2022 & 515,916 & 530,520 & 511,537 & 517,172 & 510,865 & 518,825 & $19,642 & 514,270 \\ \hline 7 & 6/28/2022 & 515,550 & 514,810 & 511,080 & $10,786 & $11,833 & $16,189 & $11,298 & 514,005 \\ \hline 8 & 6/29/2022 & 513,917 & $16.240 & 516.724 & 513.137 & $12,069 & 512,234 & 512,664 & $18,767 \\ \hline 9 & 6/30/2022 & $17,450 & $11,122 & $15,141 & $11,087 & 515,244 & 514,538 & 518,313 & 519,479 \\ \hline 10 & 7/1/2022 & 515,283. & 514,334 & $13,501 & 515,826 & 514,125 & 512,586 & $13,764 & 510,461 \\ \hline 11 & 7/2/2022 & 521,995 & 517,869 & 521,658 & 522,647 & 519,776 & 516,706 & 515,436 & $24,637 \\ \hline 12 & 7/3/2022 & 520,748 & 524,940 & 520,364 & 523,030 & 520,772 & 520,081 & 523,224 & 571,618 \\ \hline 13 & 7/4/2022 & $14,978 & 517.789 & 510,482 & 518,946 & 514,949 & 512,289 & 517,518 & $13,306 \\ \hline 14 & 7/5/2022 & 517.554 & 519,182 & $19,386 & $19,429 & 518,517 & 512,048 & $12,723 & $18,762 \\ \hline 15 & 7/6/2022 & 519,581 & $19,811 & 511,796 & 513,972 & $19,941 & 519,990 & \multicolumn{2}{|c|}{ S11,030 no data } \\ \hline 16 & 7/7/2022 & 517,039 & $19,048 & $16.155 & $13,056 & $12,490 & 518,025 & 515,412 & 519,854 \\ \hline \multicolumn{10}{|l|}{17} \\ \hline & & STORE & STORE & STORE & STORE & STORE & STORE & STORE & STORE \\ \hline \end{tabular}