ChatterBank32 mins ago
Excel - SUMIF Criteria
0 Answers
Using the SUMIF function, I have a column of data as the range, and another as the sum range.
As the criterion for the SUMIF, I have a test on a VLOOKUP. I'm using the range column above as the lookup value, an array of two columns as the table array and 2 as the column number, then testing if the second column of the array equals "FALSE"
Can the SUMIF function take a VLOOKUP as its criterion? I'm not getting the result I expected.
The formula I used is almost identical to the one below, but for the sheet name.
=SUMIF($F$3:$F$1487,VLOOKUP($F$3:$F$1487,Sheet!$E:$F,2)="FALSE",$G$3:$G$1487)
TIA
As the criterion for the SUMIF, I have a test on a VLOOKUP. I'm using the range column above as the lookup value, an array of two columns as the table array and 2 as the column number, then testing if the second column of the array equals "FALSE"
Can the SUMIF function take a VLOOKUP as its criterion? I'm not getting the result I expected.
The formula I used is almost identical to the one below, but for the sheet name.
=SUMIF($F$3:$F$1487,VLOOKUP($F$3:$F$1487,Sheet!$E:$F,2)="FALSE",$G$3:$G$1487)
TIA
Answers
Best Answer
Nobody has yet answered this question. Once some answers have been given, tell-me-more will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There are no answers available for this question.
Latest Posts
Quizzes & Puzzles73 mins ago
Quizzes & Puzzles94 mins ago
Quizzes & Puzzles99 mins ago
Quizzes & Puzzles103 mins ago
Home & Garden167 mins ago
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.