LinkBack URL
About LinkBacks
Dear Excellers,
I'm missing a piece in the following puzzle.
I want countif to skip blank cells. Otherwise the averages aren't right.
I made an example in the attachment.
Thanks for your help in advance.
psj
Dear Excellers,
I'm missing a piece in the following puzzle.
I want countif to skip blank cells. Otherwise the averages aren't right.
I made an example in the attachment.
Thanks for your help in advance.
psj
Try in
I2=AVERAGE(IF(($B$2:$B$38<>"")*($A$2:$A$38=$D2),$B$2:$B$38)) with control+Shift+enter and drag down.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Or change your formula as follow.
F2=COUNTIFS(A:A,D2,B:B,">"&0) andd rag down@@@
The 2nd formula is working thanks a lot!
(The first one gives me a lower average.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks