Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA IN EXCEL
How do I get excel to count and sum cells that contain word variables?
Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of cellls that equal "z" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA IN EXCEL
Try useing COUNTA()
= COUNTA(A2:A2) will return 2 Be careful not to use the spacebar to erase values. "BRUISER1" wrote in message ... How do I get excel to count and sum cells that contain word variables? Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of cellls that equal "z" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA IN EXCEL
One way:
A3: =COUNTIF(A1:A2,"z") In article , "BRUISER1" wrote: How do I get excel to count and sum cells that contain word variables? Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of cellls that equal "z" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA IN EXCEL
sThanks big help...how would I get 2 different criteria to add?
Ex If A1=z and B2 =y then count but if A1=z and B2=z then dont count Only count when the both criteria is met. "JE McGimpsey" wrote: One way: A3: =COUNTIF(A1:A2,"z") In article , "BRUISER1" wrote: How do I get excel to count and sum cells that contain word variables? Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of cellls that equal "z" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA IN EXCEL
Hi
i think you're after the sumproduct function =SUMPRODUCT(--(A1="z"),--(B1="y")) check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details on how this function works -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "BRUISER1" wrote in message ... sThanks big help...how would I get 2 different criteria to add? Ex If A1=z and B2 =y then count but if A1=z and B2=z then dont count Only count when the both criteria is met. "JE McGimpsey" wrote: One way: A3: =COUNTIF(A1:A2,"z") In article , "BRUISER1" wrote: How do I get excel to count and sum cells that contain word variables? Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of cellls that equal "z" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |