Charts are definitely my downfall. I'm trying to have this chart look like the example (under actual chart) - so the two categories each have the respective labels
| Renovo RFP Renewal ___Cornwall_renewal 10.1.24.xlsx | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 1 | ||||||||||||||||||
| 2 | ||||||||||||||||||
| 3 | Biomed | Imaging | ||||||||||||||||
| 4 | PrvCvg | AM Revenue (Current) | AM Revenue (FSWP) | AM Revenue (PMWP) | AM Revenue (Current) | AM Revenue (FSWP) | AM Revenue (PMWP) | Category | Current Total Cost | FSWP Estimate | PMWP Estimate | |||||||
| 5 | FSWP | $390,010 | $973,532 | $275,049 | $78,698 | $1,498,186 | $42,650 | Biomed | $999,624 | $1,046,692 | $743,268 | |||||||
| 6 | less than FS | $19,666 | $3,486 | Imaging | $123,068 | $1,501,049 | $81,723 | |||||||||||
| 7 | multiple Cvgs | $33,956 | $0 | $1,122,692 | $2,547,741 | $824,991 | ||||||||||||
| 8 | none | $66 | $0 | |||||||||||||||
| 9 | T&M | $555,926 | $73,160 | $468,218 | $40,884 | $2,862 | $39,073 | |||||||||||
| 10 | $999,624 | $1,046,692 | $743,268 | $123,068 | $1,501,049 | $81,723 | ||||||||||||
| 11 | ||||||||||||||||||
| 12 | ||||||||||||||||||
| 13 | ||||||||||||||||||
| 14 | ||||||||||||||||||
| 15 | ||||||||||||||||||
| 16 | ||||||||||||||||||
| 17 | ||||||||||||||||||
| 18 | ||||||||||||||||||
| 19 | ||||||||||||||||||
| 20 | ||||||||||||||||||
| 21 | ||||||||||||||||||
| 22 | ||||||||||||||||||
| 23 | ||||||||||||||||||
| 24 | ||||||||||||||||||
| 25 | ||||||||||||||||||
| 26 | ||||||||||||||||||
| 27 | ||||||||||||||||||
| 28 | ||||||||||||||||||
| 29 | ||||||||||||||||||
| 30 | ||||||||||||||||||
| 31 | ||||||||||||||||||
Data Input | ||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D5 | D5 | =SUMIFS('Priced Inv'!$K:$K,'Priced Inv'!$T:$T,$C$3) |
| E5 | E5 | =SUMIFS('Priced Inv'!$L:$L,'Priced Inv'!$T:$T,$C$3) |
| G5 | G5 | =SUMIFS('Priced Inv'!$K:$K,'Priced Inv'!$T:$T,$F$3) |
| H5 | H5 | =SUMIFS('Priced Inv'!$L:$L,'Priced Inv'!$T:$T,$F$3) |
| L5:N5 | L5 | =C10 |
| L6:N6 | L6 | =F10 |
| L7:N7 | L7 | =SUM(L5:L6) |
| C5:C8 | C5 | =SUMIFS('Priced Inv'!$S:$S,'Priced Inv'!$T:$T,$C$3,'Priced Inv'!$U:$U,$B5) |
| F5:F8 | F5 | =SUMIFS('Priced Inv'!$S:$S,'Priced Inv'!$T:$T,$F$3,'Priced Inv'!$U:$U,$B5) |
| C9 | C9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$C$3) |
| D9 | D9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$C$3,'2020 T&M billables'!$D:$D,"yes") |
| E9 | E9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$C$3,'2020 T&M billables'!$E:$E,"yes") |
| F9 | F9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$F$3) |
| G9 | G9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$F$3,'2020 T&M billables'!$D:$D,"yes") |
| H9 | H9 | =SUMIFS('2020 T&M billables'!$W:$W,'2020 T&M billables'!$F:$F,$F$3,'2020 T&M billables'!$E:$E,"yes") |
| C10:H10 | C10 | =SUM(C5:C9) |
