Thanks for the quick response! Part of my issue is that the ranges of the
second condition (the 3-letter code) are *not* equal to the ranges -- they
will vary month to month, so I was looking for an elegant way for Excel to
pick up the two criteria without having to add extra blank rows each month
and creating absolute cell references for each three-letter code.

"Roger Govier" wrote:

Hi

Try
=SUMPRODUCT(($A$74:$A$1001="adr")*($D$2:$D$1001="f ")*$F$2:$F$1001)

Note all ranges have to be of equal length.
--
Regards
Roger Govier

"jewel" wrote in message

Help please! I'm a beginner here and I have a working sumif function to
which I need to add a second condition. This second condition is to only
sum
if the text in column A is a certain 3-letter code. The closest I've
gotten
is a #value error that will work if I limit the text condition to just one
cell. I need the second condition to work over a range of cells. Is
this
even the right approach?

=IF(A74="adr",SUMIF($D962:$D1001,"=f",$F962:$F1001 ))

the above formula works; however I need A74="adr" to look at the range
A74:A1001 and apply the sumif to all the adr's that meet the sumif
criteria.
Hopefully, this makes sense to someone who can help. TIA!!!