Countif function
Solved/Closed
goldi
-
Nov 29, 2009 at 07:49 AM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Countif function
- Countif function in french - Guide
- Functions of spreadsheet - Articles
- Functionality of wifi - Guide
- Function key stuck on - Guide
- Acer function keys not working - Guide
3 replies
venkat1926
Nov 29, 2009 at 10:11 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Nov 29, 2009 at 10:11 PM
try this
=SUMPRODUCT((A2:A30=11)*(G2:G30="=5)*(E2:E30<>0))
assuming there are no zeroes in E2:E30
=SUMPRODUCT((A2:A30=11)*(G2:G30="=5)*(E2:E30<>0))
assuming there are no zeroes in E2:E30
venkat1926
Nov 30, 2009 at 10:20 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Nov 30, 2009 at 10:20 PM
INDIA