CountIf function ... adding another variable
Please help me!!
I am using this function/formulae:
=COUNTIF('Test Schedule'!V:V,B3)
This function counts every value equal to cell B3 appearing in the 'Test Schedule' tab in column V.
However, I want to added another variable – I don’t want to count all of these values - I want to exclude those entries where the value in 'Test Schedule' tab where column K equals “N” … that way, I only count the value where column "K" only reports on the value “Y”.
Here!
=COUNTIFS('Test Schedule'!V:V,B3,'Test Schedule'!K:K,"Y")
See if this works..
Cheers!
Deep Dave
Thanks for the reply, it would work if it showed "Y" or blanks ... sorry!! I tried =COUNTIFS('Test Schedule'!V:V,B3,'Test Schedule'!K:K,"Y","") but it errors ...
Can you please attach a sample workbook, so that the requirement can be clear..
So basically you want it to count the entries with Y as well as Blank Cells.. Is that correct?
Yes, that is correct I want to count the entries with Y as well as Blank Cells
It would have been better with a Sample Workbook, however give this a try
=COUNTIFS('Test Schedule'!V:V,B3,'Test Schedule'!K:K,"Y",'Test Schedule'!K:K,0)
Hopefully this will work
Hi, it didn't work, I have now attached ... the amount returned in total should be 68, not 71
Here!
Put this in Cell C3 on Metrics Sheet and Drag Down
=COUNTIFS('Test Schedule'!V:V,B3,'Test Schedule'!K:K,"<>"&"N")
Great, thankyou ... I will close the thread ... I didn't know what <> meant ...
Glad it helps! <> means does not equal to..
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks