lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to use sumifs() function to find out how many tv John sold for month of March. Is that possible?
I can find out how many tv john sold like this
=sumifs(E1:E10,C1:C10,"john",D1:D10,"tv")
But now I want to find out for month of March. Thank you very much
<tbody>
</tbody>
I want to use sumifs() function to find out how many tv John sold for month of March. Is that possible?
I can find out how many tv john sold like this
=sumifs(E1:E10,C1:C10,"john",D1:D10,"tv")
But now I want to find out for month of March. Thank you very much
date | store | name | item | unit |
22/1/2018 | east | john | tv | 2 |
1/2/2018 | south | mary | cell | 4 |
1/3/2018 | east | john | pc | 10 |
16/3/2018 | east | john | tv | 4 |
<tbody>
</tbody>