I have this fun formula
Formula:
=IFERROR(SUMIFS(Data!$AM:$AM,Data!$G:$G,E$6)/(SUMIFS(Data!$J:$J,Data!$G:$G,E$6)+SUMIFS(Data!$K:$K,Data!$G:$G,E$6)),0)
and was wondering if there is a way to combine the part of it that says
Formula:(SUMIFS(Data!$J:$J,Data!$G:$G,E$6)+SUMIFS(Data!$K:$K,Data!$G:$G,E$6))
into one SUMIFS formula?
Nothing critical, as the formula works as-is, just curious.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks