Issue With SUMIF and Range

		Microsoft Office Forums > Microsoft Excel > Excel
Issue With SUMIF and Range

11-11-2022, 03:42 AM

Debaser

Windows 10 Issue With SUMIF and Range

Office 2016

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

You can use:

=SUMPRODUCT(($A$2:$A$20=D22)*$D$2:$F$20)

in D23 and copy across.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using SUMIF to pull text from another cell as range	kong1802	Excel	2	02-07-2017 11:04 AM
Sumif with various conditions in the same range	Haha88	Excel	8	12-28-2016 09:15 PM
Sumif based on date range	Skumby	Excel	2	07-28-2016 10:39 PM
MS Project Date Range Issue	appelguy@gmail.com	Project	2	10-31-2015 11:52 AM
Sumif with multiple sum range	Haha88	Excel	6	10-29-2015 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 AM.