By: Patrick

]]>By: Christopher

]]>I have a set of data where in there are several dates (For eg in cell A1) and alphabets (in cell A2).

When I don’t have the alphabets in certain cells, I have the count for Dates (January 2016).

If I have the alphabet it doesnt work and I get value error

I tried this : =SUMPRODUCT((YEAR($W$7:$Z$7)=2016)*(MONTH($W$7:$Z$7)=12))

How my cells look like :

Cell A1 = 10/12/2017 (January / 2017 / Green colour)

Cell B1 = 11/12/2016 **(January / 2016 / Green colour)**

Cell C1 = 5/12/2016 **(January / 2016 / Green colour)**

Cell D1 = 8/12/2016 (January / 2016 / Yellow colour)

Cell E1 = Delivered ( some words / alphabets)

What I want :

**January/2016/Green colour**

**Result should be 2.**

**Kindly help.**

**Thanks in advance**

By: Kriti

]]>This can’t be done on a multiple range selection. Select a single range and try again. It just started doing this and I have done it multiple time before without an issue.

By: John

]]>By: wayne

]]>

I was wondering if any one could help me. I will try to explain it in writing in details.

So i have created a Tally chart on excel and i am trying to count the number of “1” that occurs based on a unqiue ID

I have a Individual per family coloumn and 6 extra coloumn to ensure if a person meet the criteria.

FamilyID |
Individual per family coloumn |
Crime/ASB 1 |
Education 2 |
Child in Need 3 |
Employment 4 |
DV/DA 5 |
Health 6 |
Count of criteria per family level | Count |

1 | 1629 | 1 | NEED A FORMULA | 3 | |||||

1 | 1629 | ||||||||

1 | 1629 | 1 | 1 | ||||||

1 | 1629 | ||||||||

2 | 1630 | 1 | |||||||

2 | 1630 | 1 | |||||||

2 | 1630 | ||||||||

2 | 1630 | ||||||||

2 | 1630 | ||||||||

3 | 1631 | 1 | 1 | ||||||

3 | 1631 | 1 | 1 | ||||||

3 | 1631 | ||||||||

3 | 1631 | ||||||||

4 | 1632 | 1 | 1 | ||||||

4 | 1632 | ||||||||

5 | 1633 | 1 | |||||||

5 | 1633 | ||||||||

5 | 1633 | 1 | |||||||

6 | 1634 | 1 | 1 | ||||||

6 | 1634 | ||||||||

6 | 1634 | ||||||||

7 | 1635 | 1 | 1 | ||||||

7 | 1635 | ||||||||

7 | 1635 | 1 | |||||||

7 | 1635 | ||||||||

8 | 1636 | 1 | 1 | ||||||

8 | 1636 | ||||||||

8 | 1636 | ||||||||

8 | 1636 | 1 |

Is there any formula that i can populate.

Please help

Kind Regards,

Viral

By: Viral Patel

]]>By: Tony M

]]>

I hope your all doing great!, Am lookin for some help in creating Random paragraphes in the same cell , I did a formula to generate random praragraphs but its not giving me a value . The idea is that we want to take cell from column 1 and we want to combine cell from column 2 and add the last column , Here is the formula and what am trying to do

=CHOOSE(250,CHOOSE(RANDBETWEEN(1,10),$A$2,$A$3,$A$4,$A$5,$A$6,$A$7,$A$8,$A$9,$A$10),CHOOSE(RANDBETWEEN(1,10),$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$B$8,$B$9,$B$10))

p1 | p2 | p3 | |

Yazan 1 | Younes 1 | Yazan and younes 1 | #VALUE! |

Yazan 2 | Younes 2 | Yazan and younes 2 | |

Yazan 3 | Younes 3 | Yazan and younes 3 | |

Yazan 4 | Younes 4 | Yazan and younes 4 | |

Yazan 5 | Younes 5 | Yazan and younes 5 | |

Yazan 6 | Younes 6 | Yazan and younes 6 | |

Yazan 7 | Younes 7 | Yazan and younes 7 | |

Yazan 8 | Younes 8 | Yazan and younes 8 | |

Yazan 9 | Younes 9 | Yazan and younes 9 |

By: Yazan

]]>

I need a helf that how to calculate square feet to cubic feet in excel,

If the square lbh was 6*3*3 feet then what was the cubic feet for this.

By: Prasanna

]]>By: Tiffany

]]>