@hollies
I am glad if you can use it.
Be aware that the formulas in column E and F are so-called array formulas. Array formulas are special in that they require to be entered a certain way. Where you normally just press Enter when you finish a formula, an array formula must be entered by holding down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. Do not try to enter these braces manually. Excel will then think it is a text string and not a formula. When you have entered one array formula correctly you can copy it to other cells as you normally do.
I do not understand what may have happened to column B in Sheet1 (Day). I surely use Scandinavian settings but I wouldn't have expected that should influence one with US settings.
I attach a file PivotTest_3 where I have converted Sheet1 back to a Table and adjusted the formulas accordingly.
Please write back should you get problems in adapting the formulas to your actual file.
|