Hi
I'm looking for a formula that will return the number of A's for each employee into a summary.
so eg detail is attached with target output
Any help gratefully received
Thanks
ian
Hi
I'm looking for a formula that will return the number of A's for each employee into a summary.
so eg detail is attached with target output
Any help gratefully received
Thanks
ian
With a slight change of layout:
=SUMPRODUCT(($B$3:$B$5=$B10)*($D$3:$F$5=C$8))
I note that the name of your attachment was Mr Excel.xlsx. Have you posted the same problem over there?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
WOW !!
Two posts for someone who joined in 2008.
Pete
First and only other post in 2009... Amazing he remembered his password!! I can't even remember what day of the week it is....
C10 cell formula , copy drag across
HTML Code:
Many thanks for the replies-that's fixed it.
No duplicate post to MrExcel, I just forgot what forum I was on.
Ian
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks