My SUMIFS formula isn't working all the time.
On my 'Data' tab, I have the raw data for a project (though the columns aren't next to each other like this):
<tbody>
</tbody>
On my 'Results' tab, I want to have a column (A:A) for each persons name and another column for their total # of jokes and want to show their total # of jokes only if they are funny. (If they're not funny then their "# of Jokes" cell is blank or zero).
<tbody>
</tbody>
This is my formula:
=SUMIFS(Data!O:O,Results!A:A,Results!A2,Data!F:F,"=Yes")
It works sometimes, other times it returns the incorrect value, and other times it returns 0 when the correct answer is nonzero.
On my 'Data' tab, I have the raw data for a project (though the columns aren't next to each other like this):
Name | Funny? (Column F) | # of Jokes (Column O) |
Suzy | No | |
Bobby | Yes | 1400 |
Larry | Yes | 3500 |
Larry | Yes | 2600 |
<tbody>
</tbody>
On my 'Results' tab, I want to have a column (A:A) for each persons name and another column for their total # of jokes and want to show their total # of jokes only if they are funny. (If they're not funny then their "# of Jokes" cell is blank or zero).
Name (Column A) | # of Jokes |
Bobby | 1400 |
Suzy | 0 |
Larry | 6100 |
<tbody>
</tbody>
This is my formula:
=SUMIFS(Data!O:O,Results!A:A,Results!A2,Data!F:F,"=Yes")
It works sometimes, other times it returns the incorrect value, and other times it returns 0 when the correct answer is nonzero.