I have this spreadsheet where we calculate times developers spend in a fiscal week.
One of my friends came up with this formula which I am unable to understand. Instead of using sumif, he used a sumproduct with a --.
A breakdown of this would be really appreciated.
Lets say I have this data.
A B C D
80 20 80% 20%
65 15 81.25% 18.75%
How do I still get this as a stacked graph with the labels from C and D, but graph corresponds to A and B