sumif with a second condition
It might have helped if I had typed ranges of equal length!!!
Those blessed fingers have a mind of their own sometimes<bg
=SUMPRODUCT(($A$74:$A$1001="adr")*($D$74:$D$1001=" f")*$F$74:$F$1001)
--
Regards
Roger Govier
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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!!!
|