Thread
:
SUMIF???
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
Posts: 8,520
SUMIF???
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.
Reply With Quote
Jacob Skaria
View Public Profile
Find all posts by Jacob Skaria