Hi,
I Need a formula to count the number of record for each salesperson in a month , i.e how many client the sales person brought in each month, I ahve attached a samaple of the sheet, two tabs, the data and the Leads count
thank you for your help
Ibraheem
See attached with Countif Formula
Eidt:
Missed your second tab showing months. You will need to use the =Countifs formula for this exercise.
Look at this link
http://www.techonthenet.com/excel/formulas/countifs.php
Last edited by alansidman; 10-24-2013 at 03:38 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello try this in leads count in B4
=SUMPRODUCT(((TEXT(Data!$B$4:$B$19,"MMM")='Leads Count'!$A4)*(Data!$C$4:$C$19='Leads Count'!B$3)))
Drag down and left to right
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thanks hemesh and alansidman
hemesh fomula worked great
You are welcome
try this one
start at B4
=SUMPRODUCT((TEXT(Data!$B$4:$B$19,"mmm")&TRIM(Data!$C$4:$C$19)=$A4&B$3)*1)
copy right and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks