Addition of true or false
Solved
helydim
Posted messages
6
Registration date
Status
Membre
Last intervention
-
helydim Posted messages 6 Registration date Status Membre Last intervention -
helydim Posted messages 6 Registration date Status Membre Last intervention -
Good evening;
I am new to Excel
I am desperately looking for a formula to sum TRUE or FALSE in the same column in order to calculate the average and then convert it to a percentage
to know that these TRUE and FALSE come from a formula that is in response to sheet 1 and that my average should be found in sheet 2 under the column of formulas transcribed as TRUE and FALSE
=IF(Sheet1!C1="buy","TRUE","FALSE")
I hope I have explained my problem clearly enough (although I doubt it)
could you tell me how to do it?
many thanks to you
I am new to Excel
I am desperately looking for a formula to sum TRUE or FALSE in the same column in order to calculate the average and then convert it to a percentage
to know that these TRUE and FALSE come from a formula that is in response to sheet 1 and that my average should be found in sheet 2 under the column of formulas transcribed as TRUE and FALSE
=IF(Sheet1!C1="buy","TRUE","FALSE")
I hope I have explained my problem clearly enough (although I doubt it)
could you tell me how to do it?
many thanks to you
4 réponses
Hello,
-1 for a header row
eric
--
By constantly trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it can be done!!!), remember to mark it as resolved. Thank you
=COUNTIF(C:C,TRUE)/(COUNTA(C:C)-1)
-1 for a header row
eric
--
By constantly trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it can be done!!!), remember to mark it as resolved. Thank you
Good evening Eric
Thank you very much for your quick response
I just tested your formula on my Excel file
unfortunately in vain
I don’t know if it’s me who is doing it wrong or if there’s an error in my file,
but the answer I get is 0
I have 119 lines with true and false
I have positioned myself on the 120th to enter your formula
(I did a copy-paste)
where am I going wrong?
do you have any idea?
thank you again for the attention you’ve given to my problem
Hely
Thank you very much for your quick response
I just tested your formula on my Excel file
unfortunately in vain
I don’t know if it’s me who is doing it wrong or if there’s an error in my file,
but the answer I get is 0
I have 119 lines with true and false
I have positioned myself on the 120th to enter your formula
(I did a copy-paste)
where am I going wrong?
do you have any idea?
thank you again for the attention you’ve given to my problem
Hely
Maybe you should mention the error...
I set it to the 120th for entering your formula
Well no, since the formula looks at the entire column, it creates an unwanted circular reference.
Put it in an adjacent column or specify the range instead of C:C
And you're allowed to thank the second intervenor, if only to indicate that you've read it.
I set it to the 120th for entering your formula
Well no, since the formula looks at the entire column, it creates an unwanted circular reference.
Put it in an adjacent column or specify the range instead of C:C
And you're allowed to thank the second intervenor, if only to indicate that you've read it.