S S P P Member Wednesday at 4:54 PM #1 How to calculate average of totals Attachments How to calculate average of totals.xlsx 12.2 KB · Views: 5
S S P P Member Wednesday at 5:27 PM #2 I got it like this =SUM(D3:D14)/COUNTIF(D3:D14;">0") If you have a better formula I would appreciate it
I got it like this =SUM(D3:D14)/COUNTIF(D3:D14;">0") If you have a better formula I would appreciate it
L Logit Active Member Wednesday at 5:49 PM #3 I had to modify your formula to : "=SUM(D3:D14)/COUNTIF(D3:D14,">0")"
S S P P Member Wednesday at 6:40 PM #4 That made it better =SE(COUNTIF(D3:D14;">0")<2;"";SE(D3:D14=0;"";SUM(D3:D14)/COUNTIF(D3:D14;">1")))
