Search:

Type: Posts; User: Garry Bettle; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: sumif but only for cells in the range that are bold

    Howdy jmiskey,

    As Mr. Sparks would say, "I like it!"

    Cheers,

    Garry
  2. Re: sumif but only for cells in the range that are bold

    Sorted!

    Thanks again everybody. All I changed was:

    SumIfBold = SumIfBold + cell.Offset(0, 1)

    to:

    SumIfBold = SumIfBold + Cells(cell.Row, 9)
  3. Re: sumif but only for cells in the range that are bold

    Howdy Mike\Jmiskey,

    Mike, that is it! Big thanks to both Mike\Jmiskey. However, just one more question:

    If I have several columns to sumbold() (for example columns A-H) and a fixed column to...
  4. Re: sumif but only for cells in the range that are bold

    Sorry jmiskey!

    Nothig is wrong with your code. Essentially, the bold cells refer to a row that has been selected, with the rows' right-most column the count column, not the column which is in...
  5. Re: sumif but only for cells in the range that are bold

    Thanks!

    However, could you help me a bit more? How would I change your code to sum a different column\range otherthan the bold one? Thanks again.

    Cheers,

    Garry
  6. Re: sumif but only for cells in the range that are bold

    Howdy All,

    Sorry to resurrect this. Can anyone help?

    Cheers,

    Garry
  7. Re: sumif but only for cells in the range that are bold

    Howdy lenze,

    There is no conditional formatting - the cells are currently made bold manually (until I use conditionally formatting!).

    Cheers,

    Garry
  8. sumif but only for cells in the range that are bold

    Howdy all,

    Great site! Quick question about how to reference a bold format of a cell. Currently, I'm able to sumif as follows:

    =SUMIF(A2:A183,1,$I$2:$I$183)

    But, what if I wanted to do the...
Results 1 to 8 of 8