Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
I was able to figure out the formulas for CNP worksheet, but not the ones for Wireless worksheet.
For CNP worksheet cell D4, I suggest a formula like:
=SUM((A4*Prices!$D$3)+(A4*Prices!$E$3))
As you copy this formula down, the references to Prices worksheet cells D3 and E3 will not change because of the $ before the row numbers.
For CNP worksheet cell F4, I suggest a formula like:
=Prices!$G$3
Once again, you may copy this formula down, and the reference to row 3 won't change.
You can see these formulas in the attached workbook.
One easy way to build a formula like these is:
1. Create the formula using placeholder values for the constants from the Prices worksheet
2. Edit the formula by selecting the placeholder value, then clicking on the Prices worksheet in the cell that contains the desired value
3. Hit the F4 key to change the cell reference from relative (Prices!D3) to absolute (Prices!$D$3). The F4 key toggles the selected part of the formula between relative addressing, absolute addressing, relative row & absolute column, and absolute row & relative column. In your case, you just need to click the F4 key once to get the absolute addressing (doesn't change as you copy down or across). transactions-examplesQ28318091.xlsx
Thank you so much! I have another workbook that uses a couple of worksheets but it is "backwards"... the third worksheet - I enter the prices, then it goes to the second for monthly and the first is the category, but I could not figure out how to get this switched.
And very odd. There was a formula even when I had it on one worksheet in the Wireless that did not work on the same row and everything matched.
Thanks for the tip, this workbook helps me much easier to separate the prices.
=SUM((A16*D$3)+(B16*E$3))
or you could use SUMPRODUCT:
=SUMPRODUCT(A16:B16,D$3:E$