Use of MIN and count function together

		Microsoft Office Forums > Microsoft Excel > Excel
Use of MIN and count function together

FAQ

Thread Tools

Display Modes

02-22-2012, 09:40 AM

khokababu

Windows XP Use of MIN and count function together

Office 2007

Novice

Join Date: Nov 2010

Posts: 2

Use of MIN and count function together

Dear Sir, If I (Physically Handicapped) get Transport allowance (10 months) Rs 2000, one month I do not get anything and one month Rs 700, The answer in cell B1 should (Rs 1600X10)+ Rs 700 = 16700, One function will leave one cell blank. But if I (Physically fit) The answer in cell B1 will be (800X10)+700=8700. How to creat function so that B1 will contain all the argument together.

Last edited by khokababu; 02-22-2012 at 10:32 AM. Reason: The question was no so clear.

Tags

count, min

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM
Count By Color	beb1227	Excel	4	06-15-2011 08:46 AM
Count in Excel	zanat0s	Excel	3	06-09-2011 10:53 AM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Don't count 0 in a chart	Rmaisone	Excel	0	08-21-2006 12:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:02 PM.