SUMPRODUCT giving #VALUE error with input of text

[addydata]

Please help - how can I ignore cells with text in for the below formula??

=SUMPRODUCT(--($P13:$AN13/$P$7:$AN$7>=0.75))+SUMPRODUCT(--($AR13:$BP13/$AR$7:$BP$7>=0.75))+SUMPRODUCT(--($BT13:$CQ13/$BT$7:$CQ$7>=0.75))

 

[DanteAmor]

Hi and welcome to MrExcel

This is an array formula:

=SUM(--(IFERROR(($P13:$AN13/$P$7:$AN$7),0)>=0.75))+SUM(--(IFERROR(($AR13:$BP13/$AR$7:$BP$7),0)>=0.75))+SUM(--(IFERROR(($BT13:$CQ13/$BT$7:$CQ$7),0)>=0.75))

Press CTRL+SHIFT+ENTER to enter array formulas.

 

[addydata]

Amazing thank you!
If tried adding an IFERROR to the below but failing. Any idea?

=COUNTA($P13:$AP13)+COUNTA($AT13:$BR13)+COUNTA(BV13:CV13)-(SUM($A13,$C13))

 

[DanteAmor]

If tried adding an IFERROR to the below but failing. Any idea?

=COUNTA($P13:$AP13)+COUNTA($AT13:$BR13)+COUNTA(BV13:CV13)-(SUM($A13,$C13))

This formula is different from your original post. You must create a thread for each topic.

However, what I can see in your formula is that Counta and Sum do not return an error if there are texts.

Examples:

Dante Amor
	A	B	C	D
1	Example 1
2	A
3			2	<-- It has 2 cells with data, it doesn't matter if they are numbers or texts.
4	2
5
6
7	Example 2
8	3		7	<-- Add 3 + 4, ignore empty cells or cells with text
9	x
10
11	4
12
13	Example 3
14	A
15	#¡DIV/0!		3	<-- It has 3 cells with data, it doesn't matter if they are numbers or texts even error
16	2
17
18	Example 4
19	3
20	x		7	To check errors it must be array formula
21	#¡DIV/0!
22	4
Sheet2

Cell Formulas
Range	Formula
C3,C15	C3	=COUNTA(A2:A4)
C8	C8	=SUM(A8:A11)
A15,A21	A15	=2/0
C20	C20	=SUM(IFERROR(A19:A22,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

Only in case of error in the cell, you could use the IFERROR function.
If you need more help you should explain what problem you have, what data you have in the cells and what you expect as a result.

Use the XL2BB tool to put a minisheet in the post.