Dave Donut
New Member
- Joined
- Dec 19, 2012
- Messages
- 27
- Office Version
- 365
- Platform
- MacOS
I am using the following function to sum the 5 smallest values in the G column.
=SMALL(G2:G100,1)+SMALL(G2:G100,2)+SMALL(G2:G100,3)+SMALL(G2:G100,4)+SMALL(G2:G100,5)
Many of the cells in the column are blank. The formula works fine when there are 5 or more cells with numbers, but sometimes there are fewer, it returns an error #NUM!.
How can I get it to return the total when there are fewer than 5 cells with numbers?
Many thanks.
=SMALL(G2:G100,1)+SMALL(G2:G100,2)+SMALL(G2:G100,3)+SMALL(G2:G100,4)+SMALL(G2:G100,5)
Many of the cells in the column are blank. The formula works fine when there are 5 or more cells with numbers, but sometimes there are fewer, it returns an error #NUM!.
How can I get it to return the total when there are fewer than 5 cells with numbers?
Many thanks.