WingSystems
New Member
- Joined
- Aug 24, 2016
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Many blessings all -
Very beginner question.
I am attempting to do a SUMIFS statement with several parameters (screenshot below).
Goal is to complete a year to date calculation based on a value in Column C. For example, if Column C = January, sum January value...if Column C = February, sum January & February values.
Struggling and drawing a complete blank on this. Is IFS statement best used here? Used incorrectly?
=IF(A6<>"",SUMIFS(E:E,A:A,A6,D:D,D6,C:C,IFS(C6=January,"January", C6="February", January OR February, C6="March", January OR MARCH OR April….. )))
Very beginner question.
I am attempting to do a SUMIFS statement with several parameters (screenshot below).
Goal is to complete a year to date calculation based on a value in Column C. For example, if Column C = January, sum January value...if Column C = February, sum January & February values.
Struggling and drawing a complete blank on this. Is IFS statement best used here? Used incorrectly?
=IF(A6<>"",SUMIFS(E:E,A:A,A6,D:D,D6,C:C,IFS(C6=January,"January", C6="February", January OR February, C6="March", January OR MARCH OR April….. )))