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