Using 2-criterias, how do I extract a column value from a 3rd
column?
On sheet_#1 I am trying to obtain a value from sheet_#2 where
the value of interest is in the 3rd column, and only extract
the value if the 1st and 2nd column meet specific criteria
(example shown below).
I have tried using SUMIF but I am unsuccessful in developing
the formula for the 2nd critera, can someone assist ?
example of intent of logic in a cell in sheet_#1
=sumif(A1:C10,("BLue" AND "Low"),C1:c10)
sheet_#2 columns
"A "B" "C"
row1 Blue High 2
row2 Blue Low 12
row3 Blue Mid 6
row4 Blue Closed 7
,,,
,,,
Thanks in advance for you help
jay
Bookmarks