Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board


View Single Post
Old 05-12-2018, 01:26 PM   #1
wilderness
Registered User
 
wilderness's Avatar
 
Join Date: Dec 2004
Location: 45th parallel
Posts: 2,178
Excel two col criteria

I'm attempting to use the criteria from two columns to SUM a third column, however one of the criteria columns is date (M/D/YYYY) and I'm only attempting to use the Year as criteria.
Tried multiple formulas and none work.

Think I'm close here, however it gives a weird Date result, rather than a SUM

=SUM(SUMIFS(B1:B210,D1210,"ABHZ",C1:C210,"*1970* "))
__________________
Best Don

Last edited by wilderness; 05-12-2018 at 01:28 PM.
wilderness is offline   Reply With Quote Reply
 
» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 06:35 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.