asked on Need help with formula in excel
i have a question
i have a table :
Program Target Actual
A 10 11
B 8 7
C 7 5
target met 2
the problem how to make the formula for target met 2
i do not want any additional columns , just the formula to update the bold number,
![example]()
i have a table :
Program Target Actual
A 10 11
B 8 7
C 7 5
target met 2
the problem how to make the formula for target met 2
i do not want any additional columns , just the formula to update the bold number,
Microsoft Excel
Last Comment
Roman F
opps, know what you mean now...
try use an Array Formula:
Press Ctrl + Shift + Enter
try use an Array Formula:
=SUM(IF(B2:B8>C2:C8,1))
Press Ctrl + Shift + Enter
ASKER
thank you, but i know that...
i do not need column e, all should be updated in c6
i do not need column e, all should be updated in c6
sample as attached.
29017184_b.xlsx
29017184_b.xlsx
ASKER
it does not work...
well, have you checked the "ver b" I uploaded in comment: ID: 42099213 above ?
it seems working fine for me in Excel ver 2010.
![snap.jpg]()
it seems working fine for me in Excel ver 2010.
ASKER
i see it does perfectly in your file, but when i implemented into my file, {} does not let formula work
ASKER
sorry, all great, thank you very much
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Open in new window
29017184.xlsx