ªð¦^¦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 : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD