I wish to Sumproduct Col B x D (from rows 5 to 10) but only if the
Value in Col M5:10 = Cars
So I could have a scenario of
ColB5 x ColD5 +

I have calculated the IRR & XIRR for the following cashflows and would expect
the results to be the same, as the cashflows are for constant periods.
As the formulas give different answers I checked the results using Solver
NPV=0 which gives a rate which agrees to the IRR result.

I would like to have few buttons ment for filtering the data in a worksheet,
with a given criteria which could be required frequently. Instead of
filtering every time, it would be useful to have few buttons.

The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]"
but I don't remember changing any setting.
Does anybody know how to get back to normal view in the formula bar, i.e
"=D9+D10"?

I need to look at the data in a particular cell then (employee name) compare
it to a list in another worksheet.  When I find the match (employe names
match) I need to read the data in the next cell (office location).
Then I need to take that data (office location) and use it to ...

I am having a problem where vlookup is not returning the next largest value
that is less than the lookup value for some reason.   The key to the data is
a column that contains a concatenated key since the values I am trying to
match on are not in contiguous columns.  The data is ...

Hello from Steved
=SUBTOTAL(($D$2:$D$2000="CITY DEPOT")*9,$B$2:$B$2000)
I have 7 Names for example City, Roskill and so on and each name has 20
products

Simple question, but I can't seem to work it out.
I have data in column A and different data in column B.  In C1 I want a
function that says TRUE when the data in B1 is somewhere in column A and
FALSE when the data in B1 can't be found anywhere in column A.

Why will using the cell number like A12 in a COUNTIF formula return the value
for the number of matching text strings and using a sub formula like
MID(A12,1,FIND(" (",A12,1)-3) in place of A12 not work?  By using the sub
formula instead of A12 I can use the same formula for the ...

Hope u can help,
Need a formula to add on to B1. I have this at the moment linking to
another sheet in B1
    A1                     B1

A problem that is causing me endless difficulties.
I want to be able to count hours/days in a working week (fine
NETWORKDAYS function and WORKDAYS to add back in ....but) and then ad
the working days back in.  I am trying to use workday to add the day

Well, after hunting on here for suggestions for how to create my own ratio
formula, I ended up (through trial and error and testing) manufacturing my
own formula.
So others don't end up in the same predicament, here's my solution with a

Referring to the post in General Question
In cell A1 = 10    
In cell A2 = 15    
In cell A3 = 20    

I am trying to do the following with the below data:
For a specific date, I need to calculate the number of transactions. A
transaction ID can appear more than once if there are several items
sold during this transaction.

I am a newby to using pivot tables. Is it possible to make a pivot table
display cummulative values. If the source of my values is by month, and I
want it to dispay cummulative in the pivot table.
For instance -- Feb = Jan+Feb, Mar = Jan+Feb+Mar, Apr =