Dear Champs,
All friends, Thanks to all for excellent solution
Regards
Amar
2013/2/6 NOORAIN ANSARI
> 1:23 PM NOORAIN: Hi Amar
> pls try
> =SUM(IF(($A$2:$A$69=F9)*($B$2:$B$69>6000),$C$2:$C$69,""))
> with ctrl+shift+enter
> --
> 13 minutes
> 1:37 PM me: thank ver
Dear Amar,
You can also try...
=SUM(IF(($A$2:$A$69=F3)*($B$2:$B$69>6000),$C$2:$C$69,""))
with ctrl+shift+Enter
On Wed, Feb 6, 2013 at 11:40 AM, amar takale wrote:
> Hi All,
> Pls suggest me Sumif formula if criteria 2 match.
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NO
hi Amar,
for sumifs formula use
=SUMIFS($C$2:$C$69,$A$2:$A$69,F3,$B$2:$B$69,">"&6000)
for all versions of excel use
=SUMPRODUCT(($A$2:$A$69=F3)*($B$2:$B$69>6000)*($C$2:$C$69))
Regards,
Aamir Shahzad
On Wed, Feb 6, 2013 at 11:29 AM, अनिल नारायण गवली
wrote:
> Dear Amar,
>
> Pl find attached . I
Hi Amar,
You can use *Sumifs formula*.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Wed, Fe
