Total within the Range or Array - and use that in a Formula

[StuartM1]

Hi,
I need help.

I need to know if the sum of ALL of the Apples is =or> 15.

In the table below it's true, but what's the cleanest way to reflect that in cells C1, C4, C6 & C11.

<table border="0" cellpadding="0" cellspacing="0" width="325"><col style="mso-width-source:userset;mso-width-alt:1901;width:39pt" width="52"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:4827;width:99pt" width="132"> <tbody><tr style="mso-height-source:userset;height:25.5pt" height="34"> <td class="xl66" style="height:25.5pt;width:39pt" height="34" width="52">
</td> <td class="xl67" style="width:48pt" width="64">Col A</td> <td class="xl68" style="width:58pt" width="77">Col B</td> <td class="xl68" style="width:99pt" width="132">Col C</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">1</td> <td class="xl69">Apple</td> <td class="xl70">2</td> <td class="xl69" align="center">TRUE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">2</td> <td class="xl69">Orange</td> <td class="xl70">5</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">3</td> <td class="xl69">Pear</td> <td class="xl70">1</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">4</td> <td class="xl69">Apple</td> <td class="xl70">3</td> <td class="xl69" align="center">TRUE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">5</td> <td class="xl69">Pear</td> <td class="xl70">4</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">6</td> <td class="xl69">Apple</td> <td class="xl70">6</td> <td class="xl69" align="center">TRUE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">7</td> <td class="xl69">Orange</td> <td class="xl70">2</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">8</td> <td class="xl69">Orange</td> <td class="xl70">2</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">9</td> <td class="xl69">Pear</td> <td class="xl70">1</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">10</td> <td class="xl69">Pear</td> <td class="xl70">1</td> <td class="xl69"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">11</td> <td class="xl69">Apple</td> <td class="xl70">5</td> <td class="xl69" align="center">TRUE</td> </tr> </tbody></table>


I need to use that result, True or False, within a formula.

I know this is bush league stuff for you folks, but I really appreciate the help.

Thanks!!!

 

[Rick Rothstein]

I'm guessing you are looking for something along these lines...

=IF(SUMIF(A1:A99,"Apple",B1:B99)>=15,"Sum of apples is greater than or equal to 15","Whoops! The sum is less than 15.")

 

[Peter_SSs]

I'll take another guess.

Excel Workbook
	A	B	C
1
2	Apple	2	TRUE
3	Orange	5
4	Pear	1
5	Apple	3	TRUE
6	Pear	4
7	Apple	6	TRUE
8	Orange	2
9	Orange	2
10	Pear	1
11	Pear	1
12	Apple	5	TRUE
SUMIF

 

[StuartM1]

You guys just rock.

Thanks!!!