kapanenship
New Member
- Joined
- Dec 14, 2007
- Messages
- 21
Need help in getting sum if array to work.
I need to sum the data array for all matching "stores", (Column B), and to make sure it is greater than the date constraint, (Column C).
I tried ...
=SUM(IF($B$9:$B$23=B4,IF($C$8:$M$8>C4,$C$9:$M$23)))
CSE
This works on the example I attached. My question is why is this not working in my actual work spreadsheet? I have narrowed it down to an issue with the date format?
Can you provide any criteria that may be the cause that I am not familiar with surrounding date formatting?
I need to sum the data array for all matching "stores", (Column B), and to make sure it is greater than the date constraint, (Column C).
I tried ...
=SUM(IF($B$9:$B$23=B4,IF($C$8:$M$8>C4,$C$9:$M$23)))
CSE
This works on the example I attached. My question is why is this not working in my actual work spreadsheet? I have narrowed it down to an issue with the date format?
Can you provide any criteria that may be the cause that I am not familiar with surrounding date formatting?
