Prev: How to mail merge multiple rows in one document
Next: access & excel issue
From: ker1378 on 11 Mar 2010 09:57
I need a formula that will sum up columns N through W but only for rows where
column C = specific word AND F = specific word.
From: Jacob Skaria on 11 Mar 2010 10:05
Try
=SUMPRODUCT((C1:C100="a")*(F1:F100="b")*(N1:W100))

--
Jacob


"ker1378" wrote:

> I need a formula that will sum up columns N through W but only for rows where
> column C = specific word AND F = specific word.
From: Bob Phillips on 11 Mar 2010 10:06
=SUMPRODUCT((C2:C200="word")*(F2:F200="other word")*(N2:W200))

--

HTH

Bob

"ker1378" <ker1378(a)discussions.microsoft.com> wrote in message
news:272BB3DB-C6B8-4AD3-B1D4-1C15D8FEEAB2(a)microsoft.com...
>I need a formula that will sum up columns N through W but only for rows
>where
> column C = specific word AND F = specific word.


From: ker1378 on 11 Mar 2010 11:12
I tried both and am getting a "#VALUE!" error

"ker1378" wrote:

> I need a formula that will sum up columns N through W but only for rows where
> column C = specific word AND F = specific word.
From: ker1378 on 11 Mar 2010 12:07
I take the last post back. I am all set now. Thank you!

"ker1378" wrote:

> I need a formula that will sum up columns N through W but only for rows where
> column C = specific word AND F = specific word.
 | 
Pages: 1
Prev: How to mail merge multiple rows in one document
Next: access & excel issue