LinkBack URL
About LinkBacks
I need help making a formula to count d2:d513 on page Jan, Feb, March, April
I need help making a formula to count d2:d513 on page Jan, Feb, March, April
hi,
sample Work Book plz
Punnam
agree on needing a sample workbook, but see if this will get you heading in teh right direction...
=COUNT(Jan:April!B2:E2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i need to create a ytd of names through the months. the names fall on d2:d513 on pages "Jan, Feb, March, April, May" some of the names are "Allen, Anthony, Joe, Matt"
i need the total of how many times a name comes up in cells d2:d513 on pages "Jan, Feb, March, April, May" and put the totals on a last page
I know how to do it with =sum(Jan!D2:d513, Feb!D2:d513, ...etc but i am not too sure with countif, or if it even possible
=COUNTIF(Jan:May!D2:D513, "Anthony")
^^^ did not work
I did not say COUNTIF(), I used COUNT()...and you did not say you wanted to count based on criteria.
See if you can adapt this...
'=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{2,3,4}&"'!C5:P5"),"Hol"))….from Tony Valco
I apologize for the Incomplete issue summary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks