Help Ms excel furmula patulong

[jawie10]

 

[That Poppy]

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

 

[jawie10]

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

 

[jawie10]

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]

The answer

 

[tango jaguar]

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