# COUNTIFS issue - Returns zero matches (possibly wrong formula???)

1. ## COUNTIFS issue - Returns zero matches (possibly wrong formula???)

Hello,

I am in the middle of designing (what will eventually be a in depth) spreadsheet showing a complete sales summary within a date range. The contents of all of the sales is on the first tab from Cognos. Basically I will then have the 2nd tab giving an indepth summary of the complete data from the first tab. One formula is not working as I expected it to.

Basically I need to give me a nice basic count total of all multiple criteria. I have used the COUNTIFS formula assuming this is correct (feel free to tell me otherwise) and the formula works but just returns a 0 result rather than the correct number.

Help....

I need column 'I' to be checked and total the count for all cells that show either 'PC' 'GV' and 'MC'.

I have attached the early stages of the spreadsheet and the current COUNTIFS formula that has no errors, just the wrong outcome.

2. ## Re: COUNTIFS issue - Returns zero matches (possibly wrong formula???)

You can use:
=SUM(COUNTIF(List_Frame_1!I:I,{"PC","MC","GV"}))

Your formula is looking for cells where column I is "PC" and is "MC" and is "GV", hence the 0.

3. ## Re: COUNTIFS issue - Returns zero matches (possibly wrong formula???)

You could count all codes in one go using a Pivot Table.

4. ## Re: COUNTIFS issue - Returns zero matches (possibly wrong formula???)

=SUM(COUNTIFS(List_Frame_1!I:I,{"PC","MC","GV"}))
Try this formula

5. ## Re: COUNTIFS issue - Returns zero matches (possibly wrong formula???)

Try with the below array formula, to be entered with ctrl+shift+enter

Formula:
`Please Login or Register  to view this content.`

6. ## Re: COUNTIFS issue - Returns zero matches (possibly wrong formula???)

Perfect - Added the SUM. Works fine. Makes sense.

Thanks guys.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1