- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- What did I do wrong THIS time?

Subject: | What did I do wrong THIS time? |

Posted by: | Nick Xylas (nickxyl…@wmconnect.com) |

Date: | 22 Jan 2007 |

I am trying to add up the value of the numbers in a range of cells in

which some cells contain numbers and others contain text. In the sum

cell, I typed the formula "=SUMIF(A1:C9,ISNUMBER(A1:C9),A1:C9)". The

result should have been 434.5, but actually came out to zero. Can

anybody tell me what is wrong with my formula and how to correct it?

- Re: What did I do wrong THIS time? posted by meatshield on 22 Jan 2007
- Re: What did I do wrong THIS time? posted by Dave Peterson on Mon, 22 Jan 2007