TanishaS09
New Member
- Joined
- Jun 3, 2019
- Messages
- 6
Hi! I am trying to do a SumIfs statement. I have a data validation list in a column and and trying to sum if the criteria in that one column matches. All of the posts I have seen have the criteria to look for in separate columns. Is it possible to do a SumIfs if all of the criteria are in the same column? Here is my attempt:
=sumifs(I8:I24,G8:G24,"Company CC",I8:I24,G8:H24,"Company CK",I8:I24,G8:H24,"Company Cash") Thanks!
=sumifs(I8:I24,G8:G24,"Company CC",I8:I24,G8:H24,"Company CK",I8:I24,G8:H24,"Company Cash") Thanks!