Forum Discussion

dazedandconfused's avatar
dazedandconfused
Copper Contributor
Sep 11, 2019

Totaling using two sets of data

I am trying to count and get the total of 2 sets of data: one set includes dates, the other includes words. The dates all include month, day, and years, but the data I would like to use in my results...
COUNTIF
COUNTIFS
date
Totaling
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Sep 11, 2019

Hi dazedandconfused 

 

You are adding result of two countifs that is the reason you do not get the result.

You can use below formula: 

 

=COUNTIFS($D$2:$D$10,"axles",$E$2:$E$10,">="&DATE(2016,1,1),$E$2:$E$10,"<="&DATE(2016,12,31))

 

Sample file is also attached for your reference.

Thanks

Tauqeer

Resources