Excel Gods,
I am having trouble with my sumifs formula. I added a new constraint so my formula isn’t coming out exactly with the totals it should be.
My worksheet called DP4Q2013 is exactly the same as worksheet 4Q2013Incurred except for the fact I added two new columns M:N to my table in worksheet DP4Q2013.
The problem I am having is with columns AB:AG of worksheet DP4Q2013.
The formula I have in 4Q2013Incurred isThe new formula I have in=SUMIFS($P$4:$P$344,$M$4:$M$344,$U4&"_G")
The problem with my new formula is it doesn’t account for a few sum ranges that do not have N/A at the end of it. Some sumranges have A03, A07, A51, etc. at the end instead of N/A so my formula doesn’t sum it all of and therefore for my totals don’t match.DP4Q2013 is =SUMIFS($S$4:$S$178,$P$4:$P$178,$X4&"_G_N/A")
Help would be greatly appreciated and thank you!
ExcelHelp.xlsx
Bookmarks