Hello
I need to sum data base on three conditions:
1. account nr.
2. date
3. "credit" or "debit"
This formula doesn't works: =SUM(($A$2:$A$22=$G$4)*($B$2:$B$22=$G$2)*($D$2:$D$22=G6))
I attached file.
Thankssum.xlsx
Hello
I need to sum data base on three conditions:
1. account nr.
2. date
3. "credit" or "debit"
This formula doesn't works: =SUM(($A$2:$A$22=$G$4)*($B$2:$B$22=$G$2)*($D$2:$D$22=G6))
I attached file.
Thankssum.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks