excel help in understanding a calculation

Hi,

Someone just gave me an 80MB excel with lots of calculations and when I look at the calculation it looks like this

=(SUMIFS(RawData!H:H,RawData!$A:$A,A$1,RawData!$C:$C,$Q4)-SUMIFS(RawData!$L:$L,RawData!$A:$A,A$1,RawData!$C:$C,$Q4))/SUMIF(RawData!$A:$A,$A$1,RawData!$L:$L)

Can someone please tell me what that means as I am not used to these cryptic calculations

thanks
-anshu
anshumaEngineeringAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tj aCommented:
It's in 3 parts so think (A-B)/C

Calculation A is summing values in column H when:
- anything in column A is equal to whatever value is in cell A1.
- anything in column C is equal to whatever value is in vell Q4.

Calculation B is summing values in column L when:
- anything in column A is equal to whatever value is in cell A1.
- anything in column C is equal to whatever value is in cell Q4.

Calculation C is summing values in column L when anything in column A is equal to the value in A1.

Given the limited information you provided, this is as much as I can understand. If you provide the names/titles of the columns in the formula (column A, L, Q, C) I "might" give a better answer.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Saurabh Singh TeotiaCommented:
anshu,

Sumifs and Sumif formula are two formulas given in excel which gives you the sum of the range when particular condition is met..

Now in Sumifs(the first range is the range of which you need the sum,criteria1 range,crietria1,criteria2 range,criteria2, ,criteria 3 range,criteria3.. etc etc)

What this essentially does it will give you the sum of the first range which you mentioned where all the criteria's which you specified are met. It's basically applying filter to the range basis of your criteria and give you the sum of the subset range where all the criteria are meet.. Note the filter which is applied is AND that is basically all the criteria's should met..

Similarly Sumif only works with 1 criteria and that is the difference between sumif and sumifs that sumifs can work on multiple criteria and sumif will work only in 1..

SUMIF formula goes like this...

=sumif(criteria range,criteria to check,range to sum)

Hope this helps providing you the formula understanding...

Further details provided by Microsoft on this Link

Saurabh...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.