software

Sample table below

The formula will be in cell f5

=IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))

If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
mulitiplied by a1:a4.

I will be using this formula in b5, c5,d5, e5. The actual table is bigger
and the numbers will change.

A B C D E F

1 10% 15.58 38.50 26.68 9.43 N/A

2 10% 13.51 36.03 24.85 6.41 3.34

3 4% 8.41 28.66 20.26 4.86 N/A

4 4% 3.67 1. 36 15.75 9.89 9.2

5Try one of these ARRAY FORMULAS*:

F5: =IF(COUNTIF(F1:F4,quot;N/Aquot;)gt;0,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))

or

F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
This one returns N/A if any cell contains text.

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;sweetsue516quot; wrote:

gt; Sample table below
gt;
gt; The formula will be in cell f5
gt;
gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt;
gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; mulitiplied by a1:a4.
gt;
gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; and the numbers will change.
gt;
gt; A B C D E F
gt;
gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt;
gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt;
gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt;
gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt;
gt; 5
gt;
gt;
gt;
gt;

Maybe this will help.........

=IF(ISNA(SUMPRODUCT(F1:F4,$A$1:$A$4)),quot;quot;,SUMPRODUC T(F1:F4,$A$1:$A$4))Vaya con Dios,
Chuck, CABGx3quot;sweetsue516quot; wrote:

gt; Sample table below
gt;
gt; The formula will be in cell f5
gt;
gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt;
gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; mulitiplied by a1:a4.
gt;
gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; and the numbers will change.
gt;
gt; A B C D E F
gt;
gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt;
gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt;
gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt;
gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt;
gt; 5
gt;
gt;
gt;
gt;

In column b through e there should be a number, then in column f there should
be a N/A.

If there is a N/A in the column N/A, if there are only numbers then
multiply that column times column A
quot;CLRquot; wrote:

gt; Maybe this will help.........
gt;
gt; =IF(ISNA(SUMPRODUCT(F1:F4,$A$1:$A$4)),quot;quot;,SUMPRODUC T(F1:F4,$A$1:$A$4))
gt;
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;sweetsue516quot; wrote:
gt;
gt; gt; Sample table below
gt; gt;
gt; gt; The formula will be in cell f5
gt; gt;
gt; gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt; gt;
gt; gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; gt; mulitiplied by a1:a4.
gt; gt;
gt; gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; gt; and the numbers will change.
gt; gt;
gt; gt; A B C D E F
gt; gt;
gt; gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt; gt;
gt; gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt; gt;
gt; gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt; gt;
gt; gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt; gt;
gt; gt; 5
gt; gt;
gt; gt;
gt; gt;
gt; gt;

Ron,

I need a sum of that column times column A, if in that column there is not a
N/A.

I think the count will count how many not give me the total I need. Right??

quot;Ron Coderrequot; wrote:

gt; Try one of these ARRAY FORMULAS*:
gt;
gt; F5: =IF(COUNTIF(F1:F4,quot;N/Aquot;)gt;0,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt;
gt; or
gt;
gt; F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; This one returns N/A if any cell contains text.
gt;
gt; Note: For array formulas, hold down [Ctrl] and [Shift] when you press
gt; [Enter], instead of just pressing [Enter].
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;sweetsue516quot; wrote:
gt;
gt; gt; Sample table below
gt; gt;
gt; gt; The formula will be in cell f5
gt; gt;
gt; gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt; gt;
gt; gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; gt; mulitiplied by a1:a4.
gt; gt;
gt; gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; gt; and the numbers will change.
gt; gt;
gt; gt; A B C D E F
gt; gt;
gt; gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt; gt;
gt; gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt; gt;
gt; gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt; gt;
gt; gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt; gt;
gt; gt; 5
gt; gt;
gt; gt;
gt; gt;
gt; gt;

Regarding:

F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))

That fomula counts the numeric cells in F1:F4.

If that count is NOT 4, then there is at least one text cell...so return: N/A

Otherwise, multiply each Col_F value by its corresponding Col_A value and
sum the products.

Am I missing something? Can an you give an example?
***********
Regards,
Ron

XL2002, WinXPquot;sweetsue516quot; wrote:

gt; Ron,
gt;
gt; I need a sum of that column times column A, if in that column there is not a
gt; N/A.
gt;
gt; I think the count will count how many not give me the total I need. Right??
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try one of these ARRAY FORMULAS*:
gt; gt;
gt; gt; F5: =IF(COUNTIF(F1:F4,quot;N/Aquot;)gt;0,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; gt;
gt; gt; or
gt; gt;
gt; gt; F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; gt; This one returns N/A if any cell contains text.
gt; gt;
gt; gt; Note: For array formulas, hold down [Ctrl] and [Shift] when you press
gt; gt; [Enter], instead of just pressing [Enter].
gt; gt;
gt; gt; Does that help?
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP
gt; gt;
gt; gt;
gt; gt; quot;sweetsue516quot; wrote:
gt; gt;
gt; gt; gt; Sample table below
gt; gt; gt;
gt; gt; gt; The formula will be in cell f5
gt; gt; gt;
gt; gt; gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt; gt; gt;
gt; gt; gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; gt; gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; gt; gt; mulitiplied by a1:a4.
gt; gt; gt;
gt; gt; gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; gt; gt; and the numbers will change.
gt; gt; gt;
gt; gt; gt; A B C D E F
gt; gt; gt;
gt; gt; gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt; gt; gt;
gt; gt; gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt; gt; gt;
gt; gt; gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt; gt; gt;
gt; gt; gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt; gt; gt;
gt; gt; gt; 5
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

The first formulas did work. Sorry for the mis understanding.

quot;Ron Coderrequot; wrote:

gt; Regarding:
gt;
gt; F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt;
gt; That fomula counts the numeric cells in F1:F4.
gt;
gt; If that count is NOT 4, then there is at least one text cell...so return: N/A
gt;
gt; Otherwise, multiply each Col_F value by its corresponding Col_A value and
gt; sum the products.
gt;
gt; Am I missing something? Can an you give an example?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;sweetsue516quot; wrote:
gt;
gt; gt; Ron,
gt; gt;
gt; gt; I need a sum of that column times column A, if in that column there is not a
gt; gt; N/A.
gt; gt;
gt; gt; I think the count will count how many not give me the total I need. Right??
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Try one of these ARRAY FORMULAS*:
gt; gt; gt;
gt; gt; gt; F5: =IF(COUNTIF(F1:F4,quot;N/Aquot;)gt;0,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; gt; gt;
gt; gt; gt; or
gt; gt; gt;
gt; gt; gt; F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; gt; gt; This one returns N/A if any cell contains text.
gt; gt; gt;
gt; gt; gt; Note: For array formulas, hold down [Ctrl] and [Shift] when you press
gt; gt; gt; [Enter], instead of just pressing [Enter].
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;sweetsue516quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Sample table below
gt; gt; gt; gt;
gt; gt; gt; gt; The formula will be in cell f5
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt; gt; gt; gt;
gt; gt; gt; gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; gt; gt; gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; gt; gt; gt; mulitiplied by a1:a4.
gt; gt; gt; gt;
gt; gt; gt; gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; gt; gt; gt; and the numbers will change.
gt; gt; gt; gt;
gt; gt; gt; gt; A B C D E F
gt; gt; gt; gt;
gt; gt; gt; gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt; gt; gt; gt;
gt; gt; gt; gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt; gt; gt; gt;
gt; gt; gt; gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt; gt; gt; gt;
gt; gt; gt; gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt; gt; gt; gt;
gt; gt; gt; gt; 5
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;

Sorry, I miss understood! This worked great.

Thank you.

quot;Ron Coderrequot; wrote:

gt; Try one of these ARRAY FORMULAS*:
gt;
gt; F5: =IF(COUNTIF(F1:F4,quot;N/Aquot;)gt;0,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt;
gt; or
gt;
gt; F5: =IF(COUNT(F1:F4)lt;gt;4,quot;N/Aquot;,SUMPRODUCT(F1:F4,$A$1:$A$4))
gt; This one returns N/A if any cell contains text.
gt;
gt; Note: For array formulas, hold down [Ctrl] and [Shift] when you press
gt; [Enter], instead of just pressing [Enter].
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;sweetsue516quot; wrote:
gt;
gt; gt; Sample table below
gt; gt;
gt; gt; The formula will be in cell f5
gt; gt;
gt; gt; =IF(f1:f4)=quot;N/Aquot;,quot;N/Aquot;,SUMPRODUCT(f1:f4,$A1:A4))
gt; gt;
gt; gt; If cells f1 through f4 equals quot;N/Aquot; (which is text I put in there) then in
gt; gt; cell f5 show N/A, but if f1 through f4 equal all numbers then equal f1:f4
gt; gt; mulitiplied by a1:a4.
gt; gt;
gt; gt; I will be using this formula in b5, c5,d5, e5. The actual table is bigger
gt; gt; and the numbers will change.
gt; gt;
gt; gt; A B C D E F
gt; gt;
gt; gt; 1 10% 15.58 38.50 26.68 9.43 N/A
gt; gt;
gt; gt; 2 10% 13.51 36.03 24.85 6.41 3.34
gt; gt;
gt; gt; 3 4% 8.41 28.66 20.26 4.86 N/A
gt; gt;
gt; gt; 4 4% 3.67 1. 36 15.75 9.89 9.2
gt; gt;
gt; gt; 5
gt; gt;
gt; gt;
gt; gt;
gt; gt;