• 413K Members
• 10.1K Online
• 472K Conversations

## QUOTIENTS

Occasional Visitor

# QUOTIENTS

IF i WANT TO DIVIDE A NUMERATOR BY ONLY THE NUMBER OF CELLS THAT HAVE AN ENTRY (WHICH CAN VARY), HOW WOULD I DO THAT?

2 Replies

# Re: QUOTIENTS

@RNINSF415GMAILCOM

Hi,

Supposing that the entry is 10 and the numerator is 20, you can do that using the formula below.

`=IF(A1=10,20/A1,"")`

Regards

Highlighted

# Re: QUOTIENTS

This places a slightly different interpretation on your question.  If the data entries lie within a defined Range 'Entries' then

= Numerator / COUNTA(Entries)

would do what you state.

If it were that the range is fully populated but might grow as data is appended then by placing it within a Table the range becomes dynamic.  In that case the formula would be

= Numerator / ROWS(Entries)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies