|
|
Sumif or Sumproduct? by
alarson01
I simply can't figure this out...
I have multiple locations that I need to find specific criteria and sum:
A B C ...
|
|
3 |
175 |
|
|
|
|
1 |
271 |
|
|
|
|
3 |
214 |
|
|
Count Unique Values by
Richard
Is there a formula that will count the number of unique values based on a
crriteria? For example. I have a sheet of part numbers with coresponding
purchase...
|
|
7 |
172 |
|
|
Need Help Developing Formula by
RockyFTI
Example of what I need:
Columns:
A- Qty
G- $ x 1.15
I- 135 / Qty
J- 85 / Qty
K- 60 / Qty
L- $ x 1.15
N- $ per each
|
|
4 |
206 |
|
|
DSUM - Need dynamic functionality by
Don[_23_]
I have a large table with approx. 1500 rows and 34 columns. It
compiles and summarizes payroll hours, by day of the week, type of
hour, and location.
Each...
|
|
8 |
220 |
|
|
Data comparison for duplication by
Donna
I have two workbooks. I want to compare names in one workbook to names in
another workbook so that I can delete duplicate names. What would be the
easiest...
|
|
1 |
163 |
|
|
Conditional Formatting by
it''''''''sh hardy
Hey there... I'm trying to conditionally format multiple cells but am having
issues. The format painter does not work properly. Is there a way to do it
for...
|
|
4 |
236 |
|
|
ENTERING TIME by
Cletus
I have a spreadsheet in excel that I record length of time in. How can I
enter the time and have the : automatically entered for me?
( 1 2)
|
|
13 |
382 |
|
|
IF formula for time by
Joshua
I have two columns
Time taken to complete work Completed within 24hrs
23:00 ...
|
|
8 |
273 |
|
|
Difference between date and time by
Joshua
I am trying to get the difference between date and time into the hh:mm format.
Example:
Start Date End Date Time taken to...
|
|
7 |
225 |
|
|
|
|
3 |
245 |
|
|
|
|
4 |
147 |
|
|
|
|
1 |
186 |
|
|
|
|
2 |
161 |
|
|
change cell colour according to date..... by
RichLive
Hello I would be very grateful if anyone could help pont me in the right
direction with a formula to do the following:
I have a date in field D9 and I need...
|
|
2 |
158 |
|
|
Naming a worksheet tab from a reference cell by
Finance Guru
Hi All,
Using Excel 2007
Can I name a worksheet tab from a cell contained within the worksheet. I
want to name a worksheet from the date contained in say A1...
|
June 12th, 2009 03:08 PM
by Luke M
|
2 |
161 |
|
|
Can't analyze web data by
willemeulen[_45_]
With help of a web query I update/refresh pricing data from the web, for
some reason I cannot get results using sumproduct function. What is the
problem with...
|
|
0 |
153 |
|
|
Excel 2007 -- SUMIFS v SUMPRODUCT by
MurrayBarn
I have had some very useful help from Jacob on an older version of Excel
where he sorted my problem out with SUMPRODUCT (see Problem with Syntax?
posted...
|
|
4 |
199 |
|
|
|
|
4 |
158 |