SUMIFS across multiple closed workbooks

		Microsoft Office Forums > Microsoft Excel > Excel
SUMIFS across multiple closed workbooks

FAQ

Thread Tools

Display Modes

01-14-2016, 08:55 AM

Pecoflyer

Windows 7 64bit SUMIFS across multiple closed workbooks

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Just to add to Debaser's explanation: any arithmetic operation performed on TRUE or FALSE will coerce them to 1 or 0

__________________
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
Pull the data from different closed workbooks paste into master vba	manilara	Excel Programming	2	11-19-2015 08:41 PM
Vlookup multiple workbooks	c123456	Excel	3	03-13-2015 12:59 PM
Office 2008 workbooks into Office 2011 workbooks	nfotx	Excel	0	12-07-2014 04:22 PM
Help with SUMIFS	LeFoah	Excel	2	10-20-2013 09:22 AM
Link multiple excel workbooks to publisher	bandcsaravia	Publisher	0	10-24-2011 09:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:21 AM.