Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Putting 2 formuals into one cell

0

Help.

I want to put these 2 formulas ino the same cell.

=(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*2 and =(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*1

Answer
Discuss

Discussion

i am not sure what the resultant will be or what you are wantin it to be ... the formulas as written referance the same cell range and criteria... R8:V28,"D" and R8:V28,"N" then you multiply by 2 or 1 ...

given the equ from Don the resultant will be a number that represents "the total number of D's and N's in the given range of R8:V28, where the resulting 'values' from each side of the '&' will be 'joined' as one number.

for instance you find 26 D's and 24 N's in the cell range
1st eq left side of & is: 26+24=50*2=100  and the right side of & is: 26+24=50
final 'result' looks like: 10050

without knowledge of your spreedsheet, or desired goal i cant suggest a clear answer
jhixy (rep: 2) Aug 1, '16 at 1:05 pm
Add to Discussion

Answers

0

It depends how you want to put them into a single cell...

Here is a way to "concatenate" them into a single cell:

=(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*2 & (COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*1
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login