Microsoft Office Forums - View Single Post - Automatically generate formulas from just the row numbers (auto insert the column)

Thread: Automatically generate formulas from just the row numbers (auto insert the column)

View Single Post

Old

04-25-2017, 04:37 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

You will have to use SUMPRODUCT instead of COUNTIF.

See the attached.

Are you aware that you can avoid error messages like the one in L5 by using a formula like:

=IFERROR(2/J5,"") or =IFERROR(2/J5,0)

Attached Files

Flaking data_4.xlsx (424.8 KB, 11 views)

Reply With Quote