=COUNTIFS('Full data'!A6:A100,'Raw data'!C6,'Raw data'!B6:B100,"1")
i have the above formula but its not working it returns 0
i appreciate all yer help thank you
=COUNTIFS('Full data'!A6:A100,'Raw data'!C6,'Raw data'!B6:B100,"1")
i have the above formula but its not working it returns 0
i appreciate all yer help thank you
maybe 1 instead of "1"
nope but thank u
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
COUNTIF()
COUNTIFS()
SUMPRODUCT()
Last edited by sandy666; 04-15-2018 at 05:48 PM.
here is an example book hope it helps
Tia
is that what you want?
=COUNTIF('Raw data'!$C$6:$C$60,'Full data'!$A$6:$A$14)
almost, i want to know how many times apple was at 1 (column "A" in raw data sheet)
did you check formula on Raw Data in column D ?
or
you mean you want to check "position" ?
so maybe this one
Last edited by sandy666; 04-18-2018 at 02:07 PM.
This works for me:
=COUNTIFS('Raw data'!$C$6:$C$60,A6,'Raw data'!$B$6:$B$60,1)
Hope this helps.
Pete
How about:
=COUNTIFS('Raw data'!$C$6:$C$60,A6,'Raw data'!$B$6:$B$60,1)
Quang PT
works a beaut thank you to you all for your help
ye are brill - thank you
If that takes care of your original question, & to say Thanks, pleaseIf you did it already - ignore it.
- click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then- select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks