Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have a row of data with this formula
The formula sums all cells in the column containing a zero value. However, this no longer works after formulas were inserted in the sheet resulting in a #N/A value.
Is there any way the above formula can be amended so it ignores the #N/A values please?
Many thanks!
I have a row of data with this formula
Excel Formula:
=SUMPRODUCT((ISNUMBER($A$2:$A$257))*(B2:B257=0))
The formula sums all cells in the column containing a zero value. However, this no longer works after formulas were inserted in the sheet resulting in a #N/A value.
Is there any way the above formula can be amended so it ignores the #N/A values please?
Many thanks!