Sumproduct Function

[ASPENCO]

I am using the following function to identify those cells in the range
of C9:C14 that are greater than 27 and then perform the SUMPRODUCT
function as indicated. I need to add another condition so that not
only is the number greater than 27 but also when added to a number in
another cell (let's say A1) the total is greater than fifty. How do I
modify this formula to do that? Your assistance is, as always,
tremedously appreciated. Thank you.


=SUMPRODUCT((C9:C14>27)*(C9:C14/40)*(D914))

 

[Bob Phillips]

=SUMPRODUCT((C9:C14>27)*(C9:C14+A1>50)*(C9:C14/40)*(D914))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)