ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ²Î­p¦U¶g¥X³f¼Æ¶q¤Î¥X³f¤Ñ¼Æ

¦^´_ 2# GBKEE
½Ð±Ð GBKEE ª©¤j¡G
  1. Sheets("²Î­p").Cells(xRow, xi) = Application.Sum(.Value)
  2. Sheets("²Î­p").Cells(xRow, xi + 9) = Application.CountIf(.Cells, ">0")
½Æ»s¥N½X
.Sum(.Value) »P .CountIf(.Cells, ">0") ¨äµ²ªG¬O¤@­Pªº¡A
¤@­Ó¬O¦X­p¡B¤@­Ó¬O­pºâ­È¡A¦b¹ê°È³B²z¤W¦³©Ò°Ï§O¶Ü¡H

TOP

¦^´_ 5# b9208
·PÁ§Aªº»¡©ú¡A²×©óÅé·|¤F CountIf ªº§t·N¡A
ÁÂÁ§A¡I

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD