+ Reply to Thread
Results 1 to 2 of 2

Count if values based on column header

  1. #1
    Forum Contributor
    Join Date
    01-05-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    243

    Count if values based on column header

    I am looking for a funtion to find whether the values under the header text contains "variance" based on the values greater than or equal to 1. Formula should come in H Column

    Please help
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Count if values based on column header

    Something like this...

    =IF(SUMIF($B$1:$F$1,"*Variance*",$B2:$F2)>0,"Yes","No")

    H2 copied down
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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