Hello there!,
I was wondering if someone can help. I've created a query using multiple SUMIFS statements and it works however it seems really long and I know that someone on here must know a much better way to do this! The problem is that for part of the query i want to use multiple criteria values in one criteria range. The other criteria values are okay as they only look at one range. Any ideas?
=ROUND(SUMIFS(MI_Grips!H:H,MI_Grips!E:E,A6,MI_Grips!F:F,"B",MI_Grips!G:G,"1b")+SUMIFS(MI_Grips!H:H,MI_Grips!E:E,A6,MI_Grips!F:F,"B",MI_Grips!G:G,"1f")+SUMIFS(MI_Grips!H:H,MI_Grips!E:E,A6,MI_Grips!F:F,"B",MI_Grips!G:G,"2")+SUMIFS(MI_Grips!H:H,MI_Grips!E:E,A6,MI_Grips!F:F,"B",MI_Grips!G:G,"3"),2)
Bookmarks