1

I'm new to Google sheets / excel and I'm a bit lost. Column E is found by D/C. How do I find the weighted average (B6), but only for values in the E column that have not been filled in yet?

I tried <>"" but it showed an error.

screenshot of relevant portion of google sheet

bad_coder
  • 11,289
  • 20
  • 44
  • 72
taks
  • 13
  • 4

1 Answers1

0

There are many ways to achieve that, here is a simple one

=AVERAGE.WEIGHTED(filter(E2:E5,D2:D5<>""),filter(B2:B5,D2:D5<>""))
GoranK
  • 1,628
  • 2
  • 12
  • 22