Please Help, Having Problem With Formula.
Thank You
Please Help, Having Problem With Formula.
Thank You
what are you trying to count, where is the data and where does the answer go?
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 am trying to count how many times I purchase an item monthly, when I select an item on column
B5-b11 includes the total.
I want answer to go on cell x4-x15.
Thanks to all, problems resolved on my own.
=SUM(COUNTIFS(Register[Month],Q4,Register[Year],$P$3,Register[Payee],{"Burger King","Boston","Chinese","Mcdonald's","Other Foods","Pizzeria"}&"*",Register[Payee],IF($F$4="Total","*",$F$4)&"*",Register[Gender],IF(Worksheet!$B$3="Jointly","*",Worksheet!$B$3)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks