kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
In the sheet, K2 : K1001 contain dates.
M2 : M1001 contain payment types for corresponding invoices (e.g., cash, paypal, etc.).
O2 contains paypal, for example.
J2 : J1001 contain amounts paid.
N2 : N1001 contain =MONTH(M2:M1001)
P1 is a 1
This works:
Why doesn't this and why is it not an acceptable statement [error says: there's a problem with this formula]?
M2 : M1001 contain payment types for corresponding invoices (e.g., cash, paypal, etc.).
O2 contains paypal, for example.
J2 : J1001 contain amounts paid.
N2 : N1001 contain =MONTH(M2:M1001)
P1 is a 1
This works:
Code:
=SUMIFS($J$2:$J$1001,$M$2:$M$1001,$O2,$N$2#,P$1)
Why doesn't this and why is it not an acceptable statement [error says: there's a problem with this formula]?
Code:
=SUMIFS($J$2:$J$1001,$M$2:$M$1001,$O2,MONTH(K2:K1001),P$1)