LinkBack URL
About LinkBacks
Hi Again Need Help
Unable To Get A Count For Tax Columns In Input Sheet With Month And Year
Please See Worksheet
Thank In Advance
Hi Again Need Help
Unable To Get A Count For Tax Columns In Input Sheet With Month And Year
Please See Worksheet
Thank In Advance
A better explanation of what you are attempting to achieve is needed. Try to be more specific and also provide expected results.
What does this mean?Unable To Get A Count For Tax Columns In Input Sheet With Month And Year
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please see summary sheet cell D46 I need the same results as d45 For Labor and tax Columns from the input sheet.
deleted duplicate post
Last edited by FDibbins; 05-10-2013 at 12:50 PM.
It looks to me that the formula you are using for TAX is...
=COUNTIFS(INPUT[Tax],$C$51,INPUT[Month],D39,INPUT[Year],$C$14)
you are using $C$51 as a criteria - which is the word TAX, in a range that is values
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
FD is right, you want a "count" of the number "tax" entries in the found range, just test for something other than blank:
=COUNTIFS(INPUT[Tax],"<>",INPUT[Month],D$39,INPUT[Year],$C$14)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Happy to help and thanks for the feedback
Thank To All SOLVED
See my comments below on how to mark a thread SOLVED. I will do it for you this time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks