R
RogueIT
I have a worksheet that someone inputs prices into.
the formula is
*********************************************
=sum(F1361,F1346,F1334,F1319,F1307,F1295,F1284,F1273,F1260,F1247,F1236,F1198,F1210,F1221,F1175,F1187,F1146,F1162,F1118,F1133,F1104,F1090,F1076,F1051,F1033,F986,F1001,F958,F971,F928,F898,F867,F844,F823,F795,F773,F774,F759,F744,F735,F725,F713,F683,F700,F647,F666,F622,F608,F589,F574,F560,F550,F528,F524,F511,F505,F496,F478,F472,F468,F455,F443,F438,F427,F406,F394,F368,F348,F341,F329,F318,F300,F294,F282,F276,F266,F252,F242,F232,F226,F212,F203,F178,F169,F153,F139,F130,F114,F101,F88,F75,F58,F41,f16)
**************************************************
but it returns 0.00 even though there is data there.
Is there some kind of limit I am running into?
Is there a way to us the sum function to include only cells with a yellow
background?
thanks,
RogueIT
the formula is
*********************************************
=sum(F1361,F1346,F1334,F1319,F1307,F1295,F1284,F1273,F1260,F1247,F1236,F1198,F1210,F1221,F1175,F1187,F1146,F1162,F1118,F1133,F1104,F1090,F1076,F1051,F1033,F986,F1001,F958,F971,F928,F898,F867,F844,F823,F795,F773,F774,F759,F744,F735,F725,F713,F683,F700,F647,F666,F622,F608,F589,F574,F560,F550,F528,F524,F511,F505,F496,F478,F472,F468,F455,F443,F438,F427,F406,F394,F368,F348,F341,F329,F318,F300,F294,F282,F276,F266,F252,F242,F232,F226,F212,F203,F178,F169,F153,F139,F130,F114,F101,F88,F75,F58,F41,f16)
**************************************************
but it returns 0.00 even though there is data there.
Is there some kind of limit I am running into?
Is there a way to us the sum function to include only cells with a yellow
background?
thanks,
RogueIT