Sum of 2 cells are equal to .................

[naveenakh]

Hi

I have doubt please help me,


Sum of 2 cells are equal to Grand Total of Pivot table

which formula can I use

 

[Faseeh]

Hi Naveena K H


You can use following with changes applicable to your data:


=IF(A1+A2>GETPIVOTDATA("Qtty",F1),"Yes","No")


Where A1 and A2 are cells you are referring to and "Qtty" is a variable in Pivot that you are summing in Values ares. You can see Excel Help for GETPIVOTDATA() and understand about "Qtty" & F1 Refrence.


Regards,

 

[naveenakh]

Thanks


But I am not clear


Please find the Link below

http://speedy.sh/trTPv/Tgs-Vs-Ach.....xls

 

[Faseeh]

Hi Naveena K H


Please try this:

=IF((L34+L74)=GETPIVOTDATA("ISP Name",'Pivot Table'!A3),"Yes","No")

Regards,


Faseeh