Is there a way to combine COUNTIFS and SUMPRODUCT?
Hello I am new to the forum and need help with a problem please. I have a formula that is working but I would like to add more criteria to it:
working now:
=COUNTIFS('Job Entry Form'!A:A,"chegan",'Job Entry Form'!L:L,"Yes")
need to add:
=SUMPRODUCT((B6>=4)*(B6<=7))
Many thanks in advance,
David
Need more of an explanation.
The COUNTIFS refers to entire columns but the SUMPRODUCT refers to a single cell.
Do you mean this:
=COUNTIFS('Job Entry Form'!A:A,"chegan",'Job Entry Form'!B:B,">=4",'Job Entry Form'!B:B,"<=7",'Job Entry Form'!L:L,"Yes")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you very much!! You got me thinking correctly. The formula is for calculating salesman bonuses.
Here are the final formulas I used:
=COUNTIFS('Job Entry Form'!A:A,A6,F:F,">=4",F:F,"<=7",'Job Entry Form'!J:J,"Yes")
=COUNTIFS('Job Entry Form'!A:A,A6,F:F,">=8",F:F,"<=11",'Job Entry Form'!J:J,"Yes")
=COUNTIFS('Job Entry Form'!A:A,A6,F:F,">=12",'Job Entry Form'!J:J,"Yes")
Again, Thank you very much for the help!
David
You're welcome. Thanks for the feedback!
If your question has been answered please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools>Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks