excell formula chahye

[lvdeeds]

salam,
please koi batayga mujhay excell ki aik sheet chahye jis main
2 coloumns ko daikhtay huye formula chahye .
complete detail or Sample sheet ap ki rehnumai k lye attach ki hai.

[Arshyat]

count if wala formula use kr k dakha hy aap ny

[Arshyat]

=countit(range your data,"ali1*20" enter

[Arshyat]

countif

[ch_kami]

salam,
please koi batayga mujhay excell ki aik sheet chahye jis main
2 coloumns ko daikhtay huye formula chahye .
complete detail or Sample sheet ap ki rehnumai k lye attach ki hai.

Yar Boss ye tu bahot assan farmula hai,,,,,,,,,,,

but sorryyyyyy,,

abi ye farmula zehan main nai arha.... .................. kal batao ga.

[lvdeeds]

apne sahi answer nahin dya kyoun k ye dono cheezain alag alag coloumn main hain

[Arshyat]

bahi kise bhe vaalue ko check kry k leay count wala formula he lagta hy

[syar]

02 formula hain.

1. =COUNTIFS(A3:A11,"1x20",B3:B11,"ali")
add criteria as required.
2. =sumproduct(--(a3:a11="1x20")--(b3:b11="ali"))

apni marzi sa ranges aur criteria add karte jain.
regards,

[syar]

02 formula hain.

1. =COUNTIFS(A3:A11,"1x20",B3:B11,"ali")
add criteria as required. See the countifs help in excel for further assisstance.


2. =sumproduct(--(a3:a11="1x20")--(b3:b11="ali"))

apni marzi sa ranges aur criteria add karte jain.

regards,

[lvdeeds]

ye formula sir 1x20 ko count kr raha hai
ali main kitnay 1x20 hain yeh nahi bata raha

[syar]

Please upload your sample sheet here. Adjust your ranges/references accordingly. As per your screen shot ali m sirf 1 he 1x20 ha.

[lvdeeds]

yeh lijye file attache hai