In cell H15 & J15 I have a sumifs formula where I am trying to sum up the values for 2 separate fields using {}. I seem to have problems when I am using the {} in one sumifs formula for 2 separate criteria, but if I only use it once in a sumifs it works fine. For instance in the attachment cells D15 & F15 are giving me the correct values. In the attachment H15 should be 24,068 and J15 should be 642,724.71 and I have the data that supports this on the query tab. Obviously I have something wrong, but not sure what I need to do to correct it.
Thanks,
Bookmarks