Sum specific entries in column that are greater than zero

		Microsoft Office Forums > Microsoft Excel > Excel
Sum specific entries in column that are greater than zero

FAQ

Thread Tools

Display Modes

08-03-2019, 06:00 PM

Lugh

Windows 10 Sum specific entries in column that are greater than zero

Office 2016

Competent Performer

Join Date: May 2019

Location: USA

Posts: 137

Very nice, p45cal

Quote:

Originally Posted by p45cal

I too found it difficult to get a worksheet formula that was easy to maintain

My first thought—before seeing your answer—was a conditional formula in Col D which would:
Count the number of numerical entries between the adjoining Col C cell and C2;
Multiply the Col C value by .1, .15 or .2 accordingly.

Won't that work, and be easy enough?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count # of times "text" is in 1 column is specific date is in the other column	ann.acornacchio	Excel	4	12-31-2016 05:40 PM
Want to copy all rows that contain a specific value in column B	mcronin	Excel Programming	3	06-15-2016 09:44 AM
Copy column entries on value	Guloluseus	Excel	3	01-05-2015 08:28 PM
Greater than today at a specific time	cangelis	Excel	6	10-01-2014 08:48 AM
Creating Calendar Entries using Specific Times	ndd811818	Outlook	0	03-04-2013 10:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 PM.