|
|
sumif? countif? by
Aaron Hodson \(Coversure\)
Hello,
I need some help with the following:
I require cell K3 (in worksheet named 'brokers') to count the number of
times the data in A3 matches those in...
|
September 3rd, 2008 04:35 PM
by Pete_UK
|
3 |
125 |
|
|
'if' formula selecting a cell from a table by
Aaron Hodson \(Coversure\)
Well, it is to me.
I am trying to create a rating matrix within excel, that can produce rates
from a table.
I have been searching through the forums for a...
|
|
3 |
90 |
|
|
|
|
2 |
50 |
|
|
Text to dictate colour of the cell and/or row by
Aaron Hodson \(Coversure\)
Hello all,
I hope someone can help.
I am trying to enter a formula to tell my spread sheet that if a value (any)
is entered into a particular cell, I would...
|
|
2 |
185 |
|
|
sumproduct and countif in one formula by
Aaron Hodson \(Coversure\)
Hello,
I have been trying for days to get the following function to work:
=SUMPRODUCT((JAN!G:G=C18)*(JAN!M:M="y"))=COUNTIF(JAN!B:B,C2)
The Sumproduct...
|
|
2 |
110 |
|
|
countifs on earlier version of excel by
Aaron Hodson \(Coversure\)
Hello,
I have been working on 2007 excel and used the below formula:
=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2)
I have just noticed upon saving that this will not...
|
|
5 |
115 |
|
|
SUMPRODUCT in earlier verions by
Aaron Hodson \(Coversure\)
Good morning,
I have the below formula which appears to work fine in 2007 but not with
earlier versions of excel.
Could someone please...
|
|
5 |
86 |
|
|
2007 excel options 'greyed out' by
Aaron Hodson \(Coversure\)
Hi all,
I seem to have a problem and not sure how to rectify,
I am trying to do some 'conditional formatting' but the option to select
this in the tool bar...
|
|
2 |
368 |
|
|
countif compatibility 2007 and earlier versions by
Aaron Hodson \(Coversure\)
Hi Mike,
Thanks for the info, sorry for the delay,,,
Just completed all sheets but have a problem with this function,
I am using 2007, so the coutifs work...
|
|
2 |
81 |
|
|
|
|
2 |
61 |
|
|
copying equations from one file to another by
Aaron Jensen
Hello everyone. I have a question regarding copying
equations from one worksheet to another. All of my
worksheets in both files have the same name. Is there...
|
|
1 |
105 |
|
|
|
|
0 |
62 |
|
|
|
|
4 |
82 |
|
|
Counting using OR? by
[email protected]
I have 2 columns and want to get the count of each row where either
one of columns in that row is = "Y" and if both are = "Y", it still
only counts as one "Y"....
|
February 20th, 2007 04:47 PM
by Bernd
|
6 |
50 |
|
|
|
December 21st, 2005 09:08 AM
by mcg
|
2 |
111 |
|
|
Data Validation by
AaronMcG
Hello all,
I am not an expert with excel. But i do use it very frequently.
And lately i've been setting up a project for my company to standardize...
|
April 17th, 2009 05:16 PM
by Kassie
|
1 |
63 |
|
|
Top half of covariance matrix by
aaronmsl
Hi
So I've used data analysis to produce a covariance matrix, however it only
generates the bottom half of the matrix. Since I want to use the matrix with...
|
|
1 |
261 |
|
|
Formula help by
Aaron[_11_]
I am looking for a way to round up a number if the decimal number is greater
than .25. I looked at the ROUND and CEILING functions but can't seem to put
a IF...
|
November 13th, 2008 04:27 PM
by Pete_UK
|
3 |
57 |
|
|
|
|
1 |
143 |
|
|
|
|
1 |
108 |