I'm attempting to create a formula to sum E:E based on text strings contained in A:A and B:B.
Here is what I tried:
=SUMIFS(D:D,A:A, "100",B:B, "Cold Call") (this is going into cell E to test it, but will be going on a different page later)
Right now its returning "0" when it should be returning a "2".
The data looks like this:
<tbody>
</tbody>
Here is what I tried:
=SUMIFS(D:D,A:A, "100",B:B, "Cold Call") (this is going into cell E to test it, but will be going on a different page later)
Right now its returning "0" when it should be returning a "2".
The data looks like this:
Column A | Column B | Column C | Column D | Column E |
04/24/13/100 | <p>Cold Call</p> | 5:00:00 PM | 1 | Testing formula here "0" |
04/24/13/107 | Proposal Delivery | 5:01:19 PM | 1 | |
04/23/13/100 | Cold Call | 3:34:12 PM | 1 | |
<tbody>
</tbody>
Last edited: