Amit

asked on

# 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

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,RawDa

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

thanks

-anshu

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.