<div>
<div class="content wysiwyg-content">
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
</div>
</div>

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

excel help in understanding a calculation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.