Formula showing the wrong result in Excel 97

N

Natasha

Hello,

I have a conditional sum formula that is not showing the
result listed in the formula box. It is designed to find
every instance of a particular phrase in column A and then
sum the corresponding cells in column F. In the formula
box it displays the correct result. However, in the cell
it displays the sum of everything in column F. I based it
on another formula I created that did work. Also if I try
to use the conditional sum wizard it won't allow me to
select any ranges to find the result in other than column
F, so I can't use the Wizard to do this.

Any help would be appreciated.

Cheers, Natasha.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Getting text or numerical data from the formula 2
Need urgent help with Excel formula 1
Why does forumula show in cell instead of formula result? 2
Return cell content in a matched range 2
Find Last entry for Col in Multi column array using cell from another array. 1
Change formulas in a column based on a selection. 3
adding multiple values from matched search results 3

Top