Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to count multiple items?
I want to set up a formula to count certain items in a row based on what the
content is. So, if the cell contains an "x" count it as 1, if it contains an "e" count it is 0.5, and then add up the values. I hope that's clear enough |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to count multiple items?
Hi!
Try this: =COUNTIF(A1:J1,"x")+COUNTIF(A1:J1,"e")/2 Biff "Mikaka" wrote in message ... I want to set up a formula to count certain items in a row based on what the content is. So, if the cell contains an "x" count it as 1, if it contains an "e" count it is 0.5, and then add up the values. I hope that's clear enough |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to count multiple items?
works great, thanks...
question though, why the division by two? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to count multiple items?
wait, i think i understand why; you're dividing the second strand of values
that are counting the e's by two, thus giving me the 0.5 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a formula to count multiple items?
question though, why the division by two?
Countif counts each instance of the criteria. Since "e" has the value of 0.5 you can either divide the total count by 2 or multiply that total count by 0.5: =COUNTIF(A1:J1,"x")+COUNTIF(A1:J1,"e")/2 =COUNTIF(A1:J1,"x")+COUNTIF(A1:J1,"e")*0.5 Dividing by 2 saves a couple of keystrokes! Biff "Mikaka" wrote in message ... works great, thanks... question though, why the division by two? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Count of items using multiple criteria | Excel Worksheet Functions |