Note: The other languages of the website are Google-translated. Back to English
Vpiši se  \/ 
x
or
x
Registracija  \/ 
x

or

Kako šteti in seštevati celice glede na barvo ozadja v Excelu?

Recimo, da imate vrsto celic z različnimi barvami ozadja, na primer rdečo, zeleno, modro in tako naprej, zdaj pa morate prešteti, koliko celic v tem obsegu ima določeno barvo ozadja, in barvne celice sešteti z isto določeno barvo . V Excelu ni neposredne formule za izračun vsote in števila barvnih celic, tukaj vam bom predstavil nekaj načinov za rešitev te težave.


Štejte in seštevajte barvne celice s filtri in SUBTOTAL

Recimo, da imamo tabelo prodaje sadja, kot je prikazano na sliki spodaj, in bomo v stolpcu Količina šteli ali seštevali barvne celice. V tem primeru lahko stolpec Količina filtriramo po barvah in nato filtrirane barvne celice s funkcijo SUBTOTAL enostavno preštejemo ali seštejemo v Excelu.

1. Izberite prazne celice, da vstopite v funkcijo SUBTOTAL.

  1. Če želite prešteti vse celice z enako barvo ozadja, vnesite formulo = SKUPAJ (102, E2: E20);
  2. Če želite sešteti vse celice z enako barvo ozadja, vnesite formulo = SKUPAJ (109, E2: E20);


Opombe: V obeh formulah je E2: E20 stolpec Količina, ki vsebuje barvne celice in jih lahko spremenite po potrebi.

2. Izberite glavo tabele in kliknite datum > filter. Oglejte si posnetek zaslona:

3. Kliknite ikono Filter  v celici z glavo stolpca Količina in kliknite Barva in določeno barvo, ki jo boste zaporedoma šteli. Oglejte si posnetek zaslona:

Po filtriranju obe formuli SUBTOTAL samodejno štejeta in seštevata vse filtrirane barvne celice v stolpcu Količina. Oglejte si posnetek zaslona:

Opombe: Ta metoda zahteva, da so barvne celice, ki jih boste prešteli ali sešteli, v istem stolpcu.

En klik za štetje, vsoto in povprečno obarvanje celic v Excelu

Z odličnim Štej po barvah značilnost Kutools za Excel, celice lahko hitro preštejete, seštevate in povprečite po določeni barvi polnila ali barvi pisave z enim samim klikom v Excelu. Poleg tega bo ta funkcija ugotovila tudi največjo in najmanjšo vrednost celic glede na barvo polnila ali barvo pisave. 30-dnevna popolna brezplačna preizkusna različica!
število oglasov po barvi 2

Kutools za Excel - Vključuje več kot 300 priročnih orodij za Excel. 30-dnevna brezplačna preizkusna različica brez kreditne kartice! Get It Now

Štetje ali vsota obarvanih celic s funkcijo GET.CELL

Pri tej metodi bomo s funkcijo GET.CELL ustvarili imenovani obseg, dobili barvno kodo celic in nato v Excelu enostavno prešteli ali sešteli po barvni kodi. Naredite naslednje:

1. Kliknite Formule > Določite ime. Oglejte si posnetek zaslona:

2. V pogovornem oknu Novo ime naredite, kot je prikazano spodaj:
(1) V polje Ime vnesite ime;
(2) Vnesite formulo = GET.CELL (38, list4! $ E2) v polje Se nanaša na (Upoštevajte: v formuli, 38 pomeni vrnitev kode celice in List4! $ E2 je prva celica v stolpcu Količina, razen glave stolpca, ki jo morate spremeniti glede na podatke v tabeli.)
(3) Kliknite OK gumb.

3. Zdaj dodajte nov stolpec Barva desno v prvotno tabelo. Nato vnesite formulo = NumColor in povlecite ročico za samodejno izpolnjevanje, da formulo uporabite v drugih celicah v stolpcu Barva. Oglejte si posnetek zaslona:
Opombe: V formuli, NumColor je imenovani obseg, ki smo ga določili v prvih dveh korakih. Spremeniti ga morate v določeno ime, ki ste ga nastavili.

Zdaj se barvna koda vsake celice v stolpcu Količina vrne v barvni stolpec. Oglejte si posnetek zaslona:

4. Kopirajte in v aktivnem delovnem listu navedite barvo polnila v praznem območju in vnesite formule zraven, kot je prikazano na sliki spodaj:
A. Če želite celice šteti po barvi, vnesite formulo = COUNTIF ($ F $ 2: $ F $ 20, NumColor);
B. Če želite celice sešteti po barvi, vnesite formulo = SUMIF ($ F $ 2: $ F $ 20, NumColor, $ E $ 2: $ E $ 20).

Opombe: V obeh formulah 2 $ F $: 20 $ F $ je stolpec Barva, NumColor je navedeni imenovani obseg, $ 2 $: $ 20 $ je stolpec Količina in jih lahko spremenite po potrebi.

Zdaj boste videli, da se celice v stolpcu Količina štejejo in seštejejo po barvah polnila.


Štetje in seštevanje celic glede na določeno barvo polnila z uporabniško določeno funkcijo

Če se barvne celice razpršijo v območju, kot je prikazano na spodnji sliki zaslona, ​​obe zgornji metodi ne moreta šteti ali seštevati barvnih celic. Tu bo ta metoda uvedla VBA za rešitev problema.

1. Držite tipko ALT + F11 in odpre tipko Microsoft Visual Basic za aplikacije okno.

2. Kliknite Vstavi > Moduliin prilepite naslednjo kodo v okno modula.

VBA: Štetje in seštevanje celic glede na barvo ozadja:

Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
Dim rCell As Range
Dim lCol As Long
Dim vResult
lCol = rColor.Interior.ColorIndex
If SUM = True Then
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = WorksheetFunction.SUM(rCell, vResult)
End If
Next rCell
Else
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = 1 + vResult
End If
Next rCell
End If
ColorFunction = vResult
End Function

3. Nato shranite kodo in uporabite naslednjo formulo:
A. Preštejte barvne celice: = barvna funkcija (A, B: C, FALSE)
B. Seštejte barvne celice: = barvna funkcija (A, B: C, TRUE)

Opomba: V zgornjih formulah A je celica z določeno barvo ozadja, za katero želite izračunati štetje in vsoto, in B: C je obseg celic, v katerem želite izračunati štetje in vsoto.

4. Na primer, naredite naslednji posnetek zaslona, ​​vnesite formulo= barvna funkcija (A1, A1: D11, FALSE) za štetje rumenih celic. In uporabite formulo = barvna funkcija (A1, A1: D11, TRUE) za seštevanje rumenih celic. Oglejte si posnetek zaslona:

5. Če želite prešteti in sešteti druge barvne celice, ponovite korak 4. Nato boste dobili naslednje rezultate:


Štetje in vsota celic glede na določeno barvo polnila s funkcijami Kutools

Kutools za Excel podpira tudi nekatere uporabne funkcije, ki uporabnikom Excela pomagajo pri posebnih izračunih, pravi štetje glede na barvo ozadja celice, vsoto po barvi pisave itd.

Kutools za Excel - Vključuje več kot 300 priročnih orodij za Excel. 30-dnevna brezplačna preizkusna različica brez kreditne kartice! Brezplačna preizkusna različica zdaj!

1. Izberite prazno celico, kamor postavite rezultate štetja, in kliknite Kutools > Kutools funkcije > Statistični in matematika > COUNTBYCELLCOLOR. Oglejte si posnetek zaslona:

2. V pogovornem oknu Funkcijski argumenti določite obseg, znotraj katerega boste šteli barvne celice v Reference izberite celico, ki je zapolnjena z določeno barvo ozadja v Color_index_nr in kliknite OK . Oglejte si posnetek zaslona:

Opombe:
(1) Vnesete lahko tudi določeno funkcijo Kutools = COUNTBYCELLCOLOR ($ A $ 1: $ E $ 20, G2)  neposredno v prazno celico ali vrstico formule, da dobite rezultate štetja;
(2) Kliknite Kutools > Kutools funkcije > Statistični in matematika > SUMBYCELLCOLOR ali tip = SUMBYCELLCOLOR ($ A $ 1: $ E $ 20, G2) v prazno celico neposredno za seštevanje celic glede na določeno barvo ozadja.
uporablja COUNTBYCELLCOLOR in SUMBYCELLCOLOR funkcije za vsako barvo ozadja posebej in dobili boste rezultate, kot je prikazano spodaj:

Kutools funkcije vsebujejo številne vgrajene funkcije, ki uporabnikom Excela olajšajo izračun, vključno z Štetje / vsota / povprečje vidnih celic, Štetje / vsota po barvi celice, Štetje / vsota glede na barvo pisave, Štejte znake, Štejte s krepko pisavo, Itd Brezplačno preskusite!


Štetje in vsota celic glede na določeno barvo polnila s programom Kutools za Excel

Z zgornjo uporabniško določeno funkcijo morate formulo vnašati eno za drugo, če je veliko različnih barv, bo ta metoda dolgočasna in dolgotrajna. Če pa že imate Kutools za ExcelJe Štej po barvah Pripomoček lahko hitro ustvarite poročilo o barvnih celicah. Ne samo, da lahko preštejete in seštevate barvne celice, temveč lahko dobite tudi povprečne, največje in najmanjše vrednosti barvnega obsega.

Kutools za Excel - Vključuje več kot 300 priročnih orodij za Excel. 30-dnevna brezplačna preizkusna različica brez kreditne kartice! Brezplačna preizkusna različica zdaj!

1. Izberite obseg, ki ga želite uporabiti, in kliknite Kutools Plus > Štej po barvah, glej posnetek zaslona:

2. In v Štej po barvah pogovorno okno, naredite, kot je prikazano na spodnji sliki zaslona:
(1) Izberite Standardno oblikovanje Iz Barvna metoda spustni seznam;
(2) Izberite Ozadje Iz Vrsta štetja spustni seznam.
(3) Kliknite gumb Ustvari poročilo.

Opombe: Če želite šteti in seštevati barvne celice glede na določeno barvo pogojnega oblikovanja, izberite Pogojno oblikovanje Iz Barvna metoda spustni seznam v zgornjem pogovornem oknu ali izberite Standardno in pogojno oblikovanje s spustnega seznama za štetje vseh celic, zapolnjenih z določeno barvo.

Zdaj boste dobili nov delovni zvezek s statističnimi podatki. Oglejte si posnetek zaslona:

O Štej po barvah funkcija izračuna celice (štetje, vsota, povprečje, največ itd.) glede na barvo ozadja ali barvo pisave. Brezplačno preskusite!


Povezani članek:


Predstavitev: Štetje in seštevanje celic glede na ozadje, barva pogojnega oblikovanja:


Kutools za Excel vsebuje več kot 300 priročnih orodij za Excel, ki jih lahko brezplačno preizkusite v 30 dneh. Prenesite in brezplačno preizkusite zdaj!

Najboljša orodja za pisarniško produktivnost

Kutools za Excel rešuje večino vaših težav in poveča vašo produktivnost za 80%

  • Ponovna uporaba: Hitro vstavite zapletene formule, grafikoni in vse, kar ste že uporabljali; Šifriraj celice z geslom; Ustvari poštni seznam in pošiljanje e-pošte ...
  • Vrstica Super Formula (enostavno urejanje več vrstic besedila in formule); Bralna postavitev (enostavno branje in urejanje velikega števila celic); Prilepite v filtrirani obseg...
  • Združi celice / vrstice / stolpce brez izgube podatkov; Vsebina razdeljenih celic; Združi podvojene vrstice / stolpce... prepreči podvojene celice; Primerjaj obsege...
  • Izberite Duplicate ali Unique Vrstice; Izberite prazne vrstice (vse celice so prazne); Super Find in Fuzzy Find v mnogih delovnih zvezkih; Naključna izbira ...
  • Natančna kopija Več celic brez spreminjanja sklica formule; Samodejno ustvarjanje referenc na več listov; Vstavi oznake, Potrditvena polja in še več ...
  • Izvleček besedila, Dodaj besedilo, Odstrani po položaju, Odstrani presledek; Ustvari in natisni vmesne seštevke strani Pretvarjanje med vsebino celic in komentarji...
  • Super filter (shranite in uporabite sheme filtrov za druge liste); Napredno razvrščanje glede na mesec / teden / dan, pogostost in drugo; Poseben filter s krepko, ležeče ...
  • Združite delovne zvezke in delovne liste; Spoji tabele na podlagi ključnih stolpcev; Razdelite podatke na več listov; Paketna pretvorba xls, xlsx in PDF...
  • Več kot 300 zmogljivih funkcij. Podpira Office / Excel 2007-2019 in 365. Podpira vse jezike. Preprosta namestitev v vašem podjetju ali organizaciji. Vse funkcije 30-dnevnega brezplačnega preskusa. 60-dnevno jamstvo za vračilo denarja.
zavihek kte 201905

Kartica Office prinaša vmesnik z zavihki v Office in poenostavi vaše delo

  • Omogočite urejanje in branje z zavihki v Wordu, Excelu, PowerPointu, Publisher, Access, Visio in Project.
  • Odprite in ustvarite več dokumentov v novih zavihkih istega okna in ne v novih oknih.
  • Poveča vašo produktivnost za 50%in vsak dan zmanjša na stotine klikov miške za vas!
dno pisarniške mize
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Md. Abdullah Sarker · 7 years ago
    Hi
    This is Abdullah Sarker.I faced one problem in excel.Please suggest me.
    Problem: How to count Or Sum Only color cell in excel.
  • To post as a guest, your comment is unpublished.
    tayyab · 7 years ago
    Perfect!! n very helpful,
  • To post as a guest, your comment is unpublished.
    sri rangavalli · 7 years ago
    hi Ian ,
    i can suggest you an alternative: try using "SUM"
    1.intially consolidate the count of different colored cells ,
    eg :in my case i used conditional formatting to "if p-equal to green color) "(say (h4:h7)ranged cells) and then used to count using formula =COUNTIF(H10:H12,"P")in some cell (say in cell C4-giving you the count of "p:green coloured cells")
    2.then similarly "if f-equal to red color) "(say (h4:h7)ranged cells) and then used to count using formula =ColorFunction(B5,H10:H12,TRUE)+COUNTIF(H10:H12,"F")in some cell (say in cell C5-giving you the count of "f:red coloured cells")
    3. then use "SUM" : =SUM(C4:C5)where c4 = count of p:green coloured cells + c5 = f:red coloured cells

    hope it helps you:)
  • To post as a guest, your comment is unpublished.
    Andy · 7 years ago
    Legend! Thanks worked a charm
  • To post as a guest, your comment is unpublished.
    Ian · 7 years ago
    I can't seem to get this to work. Does it only work for cells that have been coloured manually? I need to count cells that have been coloured via Conditional Formatting, but it's not playing ball at the moment.
    • To post as a guest, your comment is unpublished.
      Ryan · 7 years ago
      I am having the same issue as Ian, I am trying to sum numbers based on the color rules set by Conditional Formatting but this doesnt seem to catch that.

      Any Suggestions?
      • To post as a guest, your comment is unpublished.
        Jen · 7 years ago
        I threw a Powershell script that acts as a kind of work-around:

        "
        #setup Excel
        $excelApp = New-Object -comobject Excel.Application
        $excelApp.Quit()
        $excelApp.Visible = $True
        $workbook = $excelApp.Workbooks.Open("H:\Desktop\test.xlsx")#CHANGE THIS TO YOUR EXCEL FILE ADDRESS.
        $worksheet = $workbook.Worksheets.Item("Sheet1")#CHANGE THIS IF YOU SHEET ISN'T CALLED "Sheet1"

        #static variables
        $row = 1
        $column = 1#CHANGE THIS VARIABLE TO WHICHEVER COLUMN YOU'RE SEARCHING
        $totalRow = $worksheet.UsedRange.Rows.Count

        do{
        $currentCell = $worksheet.cells.item($row, $column)

        if($currentCell.text -eq "SEARCH_FOR_THIS") {
        $worksheet.cells.item($row,$column).Interior.ColorIndex = 44#CHANGE THIS NUMBER TO CHANGE THE NEW-CELL COLOUR
        "$row, $column = BLANK. Colouring"
        }
        $row++
        $row

        }
        while($row -lt $totalRow)

        "Script Complete."
        "SAVING..."

        $excelApp.Save
        $excelApp.Quit()
        [System.Runtime.Interopservices.Marshal]::ReleaseComObject($excelApp)

        "

        This script will search through your spreadsheet and if it finds a cell that contains "SEARCH_FOR_THIS" (you should probably change that part in the script) then it will turn that cell to whatever colour number is in the script (currently set to 44, a weird looking orange/tan colour). Once the script has finished it'll try and tell Excel that it wants to save, but Excel isn't a very trusting program so will ask for you to click on save. Once you've done that then it'll close down. Then, open the file back up and do all that business that listed on this page, making sure that the colour that my script it looking for it the same colour that the script listed on this page it looking for.

        Hope this helps!
      • To post as a guest, your comment is unpublished.
        Admin_jay · 7 years ago
        We will try to enhance it in the upcoming versions. :-)
  • To post as a guest, your comment is unpublished.
    sri rangavalli · 7 years ago
    Timely and apt article like hitting the target which am looking for:) thanks
  • To post as a guest, your comment is unpublished.
    James B · 7 years ago
    I have an Excel file with many coloured cells. Is there any way to convert these colours to data? So a red cell will have ''red'' in it as data, a blue coloured cell will have ''blue'' in it and so on? James
  • To post as a guest, your comment is unpublished.
    Anith · 7 years ago
    Thanks Sir,
    This is a wonderful work and helps me a lot.
  • To post as a guest, your comment is unpublished.
    Ali · 7 years ago
    dear sir ,
    in fact it is wonderful code but I faced a problem that it will continue calculate the cell even when we change the cell color
  • To post as a guest, your comment is unpublished.
    chaminda · 7 years ago
    it worked well done!!!
  • To post as a guest, your comment is unpublished.
    Ceza · 7 years ago
    This is awesome, thanks!
  • To post as a guest, your comment is unpublished.
    libin · 7 years ago
    well done..but..how it works in conditional formatting cell colors ???
  • To post as a guest, your comment is unpublished.
    Kertis · 7 years ago
    Thanks. It worked for me as described. However, after I reopened the file next time all cells with this formula were showing error. I had to re-copy the coding again. Is there something I am missing? I will need to share the file with others and they wont be able to "fix" the problem.
    Thanks, Ker.
    • To post as a guest, your comment is unpublished.
      Happiqiu · 7 years ago
      You need to save it as excel Macro workbook
  • To post as a guest, your comment is unpublished.
    aliinmegeve · 7 years ago
    Thank you SO much, i have been looking all day for a successful outcome and we now have one :)
  • To post as a guest, your comment is unpublished.
    AvGravy · 7 years ago
    Thank you so much! This is genius, thanks for the help!
  • To post as a guest, your comment is unpublished.
    RAMON · 7 years ago
    I applied the formula but the cell said NAMES? what I need to fix
    • To post as a guest, your comment is unpublished.
      skyyang · 7 years ago
      Hello RAMON, maybe you didn’t copy the above code into the Module. You must copy the code into the Module first and save it, then apply the formulas. You can try it. If it doesn’t help you, please let me know.
      • To post as a guest, your comment is unpublished.
        Mike F · 4 years ago
        Skyyang,

        If I email you a document can you help me with it?

        Mike
      • To post as a guest, your comment is unpublished.
        Alexandra · 7 years ago
        Hello, It worked the first time, but now, when I have to add a cell to the sum... I tried introducing again the code, saving, writing the formula again... it says "name?"
        • To post as a guest, your comment is unpublished.
          Daria · 7 years ago
          I'm having the same problem -- worked beautifully at first, but getting the NAME error after adding another cell. Have tried to delete module and add again, re-enter the function...no joy.
          • To post as a guest, your comment is unpublished.
            Gary_9991 · 7 years ago
            You might need to enable Marcos again. Should flash up at the top of the screen depending on version of excel. :)
  • To post as a guest, your comment is unpublished.
    Sankar Narayanan · 7 years ago
    Hi, getting error. complie error, ambiguous error is coming.
  • To post as a guest, your comment is unpublished.
    David Coe · 7 years ago
    This is great tool, thanks for sharing! I do have one question: I noticed that the macro formula does not update itself when you change a cell color from one color to another. Is there a way to get it to automatically update when cell colors change? If I double click on the cell with the addition formula and press enter, it updates, but I have a sheet with many of these cells and don't want to have to manually update it each time.
    • To post as a guest, your comment is unpublished.
      Louise · 7 years ago
      try CTL+ALT+f9 it will update all cells with addition formulas at once. Not quite automatic but at least better than having to click on each cell with addition formula individually.
      • To post as a guest, your comment is unpublished.
        ollie · 5 years ago
        this did nothing for me :(
    • To post as a guest, your comment is unpublished.
      Happiqiu · 7 years ago
      Hi, i have tried. and the worksheet just needs an "Enter" No matter which cell. So, after coloring your cell, just type a memo on the colored cells and "enter"
    • To post as a guest, your comment is unpublished.
      skyyang · 7 years ago
      Thank you for your reply, I’m sorry, under the current situation, the VBA code can’t solve the question that you pointed out, you need to update them manually.
      • To post as a guest, your comment is unpublished.
        Jako · 5 years ago
        I have also found that using the format painter to update the cell color will cause the formulas to work as expected. Still not perfect.
  • To post as a guest, your comment is unpublished.
    Shankee · 7 years ago
    Amazing,thanks a lot
  • To post as a guest, your comment is unpublished.
    Laxmannarayanan · 7 years ago
    Wonderful!!! Thank you so much!!!
  • To post as a guest, your comment is unpublished.
    imamoglu · 8 years ago
    Very useful article, thanks a lot
  • To post as a guest, your comment is unpublished.
    Petr · 8 years ago
    Very good, thanks a lot !!!
  • To post as a guest, your comment is unpublished.
    Gowrisankar · 8 years ago
    Very useful tool , Thank you verymuch
    • To post as a guest, your comment is unpublished.
      HR · 7 years ago
      Very useful. Thank you
      • To post as a guest, your comment is unpublished.
        Aniko · 5 years ago
        I also tried the formula.
        Works in the first row and does not with second and third.

        ????
        • To post as a guest, your comment is unpublished.
          Mark · 4 years ago
          Try it like this:

          1. be certain you have the function saved as described

          2. permit me to use an example
          * I have hundreds of rows of data
          * I use columns A to AB with more data
          * whenever I have an issue with my data, I highlight it in yellow
          * I use this cool formula to 'count' the number of highlights on each row

          3. How to count the number of my highlights per row
          a. figure[u] the range of cells[/u]that could have highlights that you want to count (or sum)
          * for me, I want to COUNT the quantity of my flagged highlights on each row (my range)
          b. pick a cell where you will report the count (or sum)
          * for me, I placed it on the far right of my data...in column AE
          c. insert the following formula in the cell you chose in item b (above)
          =colorfunction(AE3,A3:AB3,FALSE)
          * for me, I placed this formula in cell AE3 (the end of my row) AND AND I highlighted the same formula cell Yellow
          d. I then copied this formula down for all my data rows

          4. I observed
          a. no counts were made. (bad)

          5 KEY ISSUE HERE:
          a. I pressed CTL+ ALT + F9
          . PRESTO !!! it works.!

          hope this banter is of some help.

          Cheers




          do this:

          A B C D
          1
          2
          3
          4
        • To post as a guest, your comment is unpublished.
          Mark · 4 years ago
          I agree with Jarod.

          The first two lines of my function says:

          Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
          Application.Volatile

          The problem is that only a Alt-Ctrl-F9 will re-calculate. We're looking for a more automated solution. Ideas?
    • To post as a guest, your comment is unpublished.
      Gowrisankar · 7 years ago
      After inserting the function , when we change the value the sum not automatically udpated , any suggestion
      • To post as a guest, your comment is unpublished.
        Jacqui · 4 years ago
        I double clicked the cell with the ColorFunction formula, and then pressed Enter. It updated.
      • To post as a guest, your comment is unpublished.
        12345678998765432154 · 5 years ago
        Add a second line directly below the first that says Application.volitile it makes it recalculate after something is updated
        • To post as a guest, your comment is unpublished.
          abrugg · 5 years ago
          [quote name="12345678998765432154"]Add a second line directly below the first that says Application.volitile it makes it recalculate after something is updated[/quote]

          Application.Volatile is the correct function not Application.volitile
          • To post as a guest, your comment is unpublished.
            Jo · 5 years ago
            I don't see any line that says application.volatile.
            Where do I find it?
        • To post as a guest, your comment is unpublished.
          Jarod · 5 years ago
          I tried to put [b]Application.Volatile[/b] unde the first line and nothing hapens :(
      • To post as a guest, your comment is unpublished.
        WestwoodMike · 5 years ago
        Alt-Ctrl-F9 will re-calculate
        • To post as a guest, your comment is unpublished.
          Mike Brannigan · 3 years ago
          You can add and update button if someone else is using the file and they don't know about the Alt-Ctrl-F9. just add this line of code to the macro "Application.CalculateFull". it's that same as Alt-Ctrl-F9 just programmed into a button.