LinkBack URL
About LinkBacks
anh03 
how do i make countifs and sumifs function/formula to count and sum everything on Name range.
any suggestion or advise
thank you
=COUNTIFS($A:$A,G3,$D:$D,Docs)
=SUMIFS($C:$C,$A:$A,Docs)
how do i make countifs and sumifs function/formula to count and sum everything on Name range.
any suggestion or advise
thank you
=COUNTIFS($A:$A,G3,$D:$D,Docs)
=SUMIFS($C:$C,$A:$A,Docs)
try with CSE (control+shift+enter)
and second formula:
=SUMIFS($C:$C,$A:$A,G3,$D:$D,Docs)
with CSE
Last edited by sandy666; 04-21-2015 at 11:20 PM.
First have you tried cleaning your data (column A) and lookup references in G3:G16? Some of them have trailing space(s) while others do not. Check out "Jonathan" for example.
I haven't checked the rest......but where there is one....
After you do try this formula in H3 and fill down.Formula:
=SUMPRODUCT(COUNTIFS($A:$A,G3,$D:$D,Docs))
Then try this in I3 and fill down.Formula:=SUMPRODUCT(SUMIFS($C:$C,$D:$D,Docs,$A:$A,$G3))
Last edited by FlameRetired; 04-21-2015 at 11:46 PM.
it work
thank you
You're welcome. Glad it works.and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks