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 |
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 |
How do I set up a formula to count multiple items?
works great, thanks...
question though, why the division by two? |
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 |
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? |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com