Quizzes & Puzzles4 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 & Puzzles9 mins ago
Quizzes & Puzzles15 mins ago
Listener No. 4844 S And T By Aedites
Crosswords23 mins ago
Quizzes & Puzzles57 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.