Simple "Sum" question

Berandon

New Member
Joined
Sep 8, 2014
Messages
29
I am trying to think of an "if" function that if there is text in the cell it adds 1. So i can track how jobs of that type I have. so if (text) is in E9:E2000 then +1

Thank you
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Saryu

New Member
Joined
Sep 15, 2014
Messages
1
If you want to count the number of cell than try below function.=SUMPRODUCT(ISTEXT(E9:E2000)*1)Regards,Saryu
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,965
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top