richiwatts
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 131
I have this calculation
=SUM(E21:E68,G21:G68,I21:I68)
Is it possible to exclude any of the columns from the calculation is No is present?
If E20 says No the my calculation would be =SUM(G21:G68,I21:I68)
If G20 says No the my calculation would be =SUM(E21:E68,I21:I68)
If E20 and G20 says No the my calculation would be =SUM(I21:I68)
..and so on
Rich
=SUM(E21:E68,G21:G68,I21:I68)
Is it possible to exclude any of the columns from the calculation is No is present?
If E20 says No the my calculation would be =SUM(G21:G68,I21:I68)
If G20 says No the my calculation would be =SUM(E21:E68,I21:I68)
If E20 and G20 says No the my calculation would be =SUM(I21:I68)
..and so on
Rich