How about?
=SUMPRODUCT(--(ISNUMBER(-LEFT('Patrol Log'!A22:A43,1))))-COUNTIF('Patrol
Log'!A22:A43,"1desk")
Another way
=SUMPRODUCT(--(ISNUMBER(-LEFT('Patrol
Log'!A22:A43,1))),--(ISERROR(FIND("1desk",'Patrol Log'!A22:A43))))
Best Regards,
Peo Sjoblom
"Brian" wrote:
IN CELL B28 This formula returns the sum of a range of cells that contain
data that starts with a number, such as 1a15, 2a15, 3a15, 1b15, 2b15, etc.
=SUMPRODUCT(--(ISNUMBER(-LEFT('Patrol Log'!A22:A43,1))))
Problem is that there is one type of data that starts with a number that I
do not want counted in the sum. It is "1desk".
How can this formula be changed so as to perform my request.
Thank You
Brian
|