how do i make a formula for 3 criteria
for example, count the instances where
A:A to be equal "1"
B:B to equal "2"
C:C to equal "3"
furthermore, is it possible to conduct an average of, say C column values for the above criteria are all met?
how do i make a formula for 3 criteria
for example, count the instances where
A:A to be equal "1"
B:B to equal "2"
C:C to equal "3"
furthermore, is it possible to conduct an average of, say C column values for the above criteria are all met?
Last edited by excelnovice12345; 03-04-2011 at 12:16 PM.
Surely the average would be 3 if all criteria are met?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi,
To get the count:for example, count the instances where
Please Login or Register to view this content.
This doesn't quite make sense - the average would be 3. But, say it's column D, you would use the AVERAGEIFS() function.furthermore, is it possible to conduct an average of, say C column values for the above criteria are all met?
yea, thats what i meant, a separate column. oy... its time for the weekend. excel is def not my thing. thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks