❓ Help Ms excel furmula patulong

That Poppy · Oct 18, 2020

you mean i count sila? from Item a to B? basta di kasama at duplicate, zero and blank? like this one?

jawie10 · Oct 18, 2020

Oo,, dapat unique di kasama ang zero at blank cell.. dapat na mag kaibang cell,, kagaya ng sample ko

jawie10 · Oct 18, 2020

That Poppy said:
you mean i count sila? from Item a to B? basta di kasama at duplicate, zero and blank? like this one?

View attachment 991942

Oo,, kagaya ng sample ko 6 ang bilang ,d kasma 5,0, 1 at blank cell..,, dapat may pagitan ung column o nasa mag kaibang cell or colum

FreeAllYouCan-OFFICIAL · Oct 18, 2020

tango jaguar · Nov 26, 2020

=COUNTIF(A2:A6,">0")+COUNTIF(C2:C6,">0")-SUMPRODUCT(COUNTIF(A2:A6,C2:C6))