Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?

		Microsoft Office Forums > Microsoft Excel > Excel
Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?

FAQ

Thread Tools

Display Modes

01-08-2017, 10:38 AM

Pecoflyer

Windows 7 64bit Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi and welcome
could you please explain another way what you are trying to do ?
I don' understand at all. ( and also posting a sheet instead of an image helps)

__________________
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
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
What is the right IF function to use to sum the last above cell has value and ignore zero?	MGadAllah	Excel	1	07-15-2014 08:59 AM
How to ignore a mail merge field if the field is blank	redzan	Mail Merge	1	05-16-2013 08:34 AM
How to ignore the in between cells?	babapusy	Excel	1	01-21-2013 03:05 AM

Other Forums: Access Forums

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