Picture attached. Need one column to return sum of another column.

		Microsoft Office Forums > Microsoft Excel > Excel
Picture attached. Need one column to return sum of another column.

FAQ

Thread Tools

Display Modes

11-18-2017, 01:21 AM

Pecoflyer

Windows 7 64bit Picture attached. Need one column to return sum of another column.

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

SUMIFS is the new version of SUMPRODUCT ( but it is not a flexible)
In this case SUMIF ( without the trailing "s" would have sufficed)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Find text within cell and return column and row title next to the name on a new sheet.	tanyabowring@live.co.uk	Excel Programming	2	03-26-2015 01:48 AM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
as the return value of another column, using Listbox?	marreco	Excel Programming	1	03-27-2012 12:48 PM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM

Other Forums: Access Forums

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