Kiến thức

I just want a numerical result! Counting with Query-Google Docs Editors Community

/docs/community?hl=en
/docs/community?hl=en
12/9/17

Original Poster

Nuclear Buckeye

I just want a numerical result! Counting with Query

1 Recommended Answer

What I’m using:

=query(‘Problem Database’!D:I, “Select count(D) where H is null or I is null”).
This equation results in text: the word “count” followed by values from the D cells

I can’t seem to get any of the dozen of Count equations to work either.

This doesn’t work / results in 0:
=countifs(‘Problem Database’!$D3:$E,NOT(“”), ‘Problem Database’!F3:G, GTE(Countblank(‘Problem Database’!F3:G),1))
Community content may not be verified or up-to-date.

Learn more.

Recommended Answer
Was this answer helpful?
How can we improve it?

This question is locked and replying has been disabled. Still have questions?

Ask the Help Community

.

Bạn đang xem: I just want a numerical result! Counting with Query-Google Docs Editors Community

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 

Google Employee — Google product team members and community managers

 

Community Specialist — Google partners who help ensure the quality of community content

 

Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts

 

Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions

 

Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions

 

Product Expert Alumni — Former Product Experts who are no longer members of the program

Community content may not be verified or up-to-date.

Learn more.

Xem thêm: ĐƠN VỊ HOẠT ĐỘNG EL MONTE – Cơ quan chất lượng nước

Levels

Member levels indicate a user’s level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user’s advance in levels.

Xem thêm: Nhị thức Newton, cách khai triển và một số dạng bài tập áp dụng

View profile in forum?

To view this member’s profile, you need to leave the current Help page.

Xem thêm: Các dạng toán về luỹ thừa với số mũ tự nhiên-toán lớp 6

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button