Thread
:
SUMIF???
View Single Post
#
3
Posted to microsoft.public.excel.misc
Bob Phillips[_4_]
external usenet poster
Posts: 834
SUMIF???
=SUMPRODUCT((C2:C200="word")*(F2:F200="other word")*(N2:W200))
--
HTH
Bob
"ker1378" wrote in message
...
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.
Reply With Quote
Bob Phillips[_4_]
View Public Profile
Find all posts by Bob Phillips[_4_]