Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two worksheet, and I want to do a Sumif() function in sheet 1 but the
data is in sheet 2, I had no problem using this function in excel 2003, however; its not working in excel 2007, what Im I doing wrong? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The first thing you are doing wrong is not telling us what formula you are
using. The second thing you are doing wrong is not telling us what you mean by "not working". What were the data values, what result did you get, and what result did you expect? Unfortunately we're not very good at guessing. -- David Biddulph sjmdhd wrote: I have two worksheet, and I want to do a Sumif() function in sheet 1 but the data is in sheet 2, I had no problem using this function in excel 2003, however; it's not working in excel 2007, what I'm I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
Sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |