Calculating the Geometric Mean/Geomean of Housekeeping Genes from Real-Time PCR Data Using Excel

In real-time PCR, it is not uncommon for multiple housekeeping genes to be used for normalising data. Knowing how to calculate an average for your housekeeping genes will be useful regardless of whether you opt to carry out relative or absolute quantification of your gene of interest.

If you are using three or more housekeeping genes, you can calculate the geometric or geomean easily using Excel.

Cell Formulae

Column B: Gene 1 CT values from your qPCR run

Column C: Gene 2 CT values from your qPCR run

Column D: Housekeeping gene 1 CT values from your qPCR run

Column E: Housekeeping gene 2 CT values from your qPCR run

Column F: Housekeeping gene 3 CT values from your qPCR run

Column G: =GEOMEAN(D4:F4) and copy/paste formula down to G18