Sum of Cells based on Cell color format

[techgirl]

I have one workbook, with multiple sheets. Main data is on Sheet1, but I want the formula on sheet 2. I need to SUM a column of cells on sheet1, but only if it has a particular cell fill color. I will have two colors to use, but for now I am just trying to get one of them working.

Sheet 1 - Column Q (Q3:Q300)- pink fill color through column Q.
Sheet 1 - Example...Q3=11 Pink BG; Q4=22 white BG, Q5=10 Pink BG
Sheet 2 - D3, "# of items"
Sheet 2 - E3 (This is where the SUMIF calculation will go). =SUMIF(Sheet1!Q3:Q300,PinkBackground)
Sheet 2 - Answer for sumIF, if Pink BG...(Example numbers above) = 21

I just have one column with numbers, cell color is either pink or white.

I've seen this formula being explained, but I don't get any results from that.
=GET.CELL(63,!A1) + NOW()*0

 

[awoohaw]

Is there anyway that they could put another column of "Physician" or "Allied Health" or maybe "Physician" or "Other" so the value can be used? I think it would make sense for data integrity and who ever is reviewing the conditionally formatted cells that they are processing a correct record. (and yes, the user could input the wrong word in the new column too)