Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Combining two formulas into one
I have a cell H34 that currently counts all the YES results from rows 6 thru 30:
=COUNTIF(R6:R30,"Yes")
Then, I have a formula in a hidden column to calculate the result from rows 6 thru 30:
=IF(D6>=1,"Yes")
Is there an easier way to put just one formula into cell H34 that will give me the result I need by just doing the whole thing one time? I'd love to get rid of those hidden columns...I sometimes forget they are there and make modifications that create nightmares. Please help...I hope I've provided enough information. Just let me know if not, and I will explain it differently.
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- combining formulas two
- Participating Experts
- 4
- Solution Grade
- A
Log In
Stay Connected
Top Experts
-
mlmcc
10,880
0 points yesterday
Profile -
dlc110161
3,500
0 points yesterday
Profile -
jimpen
3,500
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
billprew
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
kgreene
1,820
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2005-12-05 at 10:35:27ID: 27203083
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.