Countifs + Contains or Find Formula Help

I require assistance please to create a formula based on two criteria:

COUNT "SPI Quoted Value" column, when >0

and when

"Date" column CONTAINS or FIND "January"

Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4.

I tried this formula, however didn't work =COUNTIFS([SPI Quoted Value]2:[SPI Quoted Value]7, >0, FIND("January", Date2:Date7))

Thanks Peta

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Jayesh Nathani

Hi Peta,

You were almost correct, try below:

=COUNTIFS(Date:Date, FIND("January", @cell) > 0, [SPI Quoted Value]:[SPI Quoted Value], >0)

Peta

Hi Jayesh,

I'm getting a result of 0, instead of 4.

Where you have @cell, what am I typing in there; @cell or a particular cell?

Jayesh Nathani

Oh I'm sorry, I didn't see that your column had commas in it.

Try this -

=COUNTIFS(Date:Date, FIND("January", @cell) > 0, [SPI Quoted Value]:[SPI Quoted Value], OR(@cell <> "0", @cell <> 0))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.