sumproduct help

Joneye

Well-known Member
Joined
May 28, 2010
Messages
745
The formula below gives me one answer of 472, what I need to do is ask the formula to also inluced the other fomula that gives me an answer of 99.

How can I construct the formula to add 472 and the 99 together.

=SUMPRODUCT(--($L$7:$L$1126=""),--($F$7:$F$1126=Q1))



=SUMPRODUCT(--($L$7:$L$1126="No"),--($F$7:$F$1126=Q5))
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Probably simplest to just add the two together like this

=SUMPRODUCT(--($L$7:$L$1126=""),--($F$7:$F$1126=Q1))+SUMPRODUCT(--($L$7:$L$1126="No"),--($F$7:$F$1126=Q5)) <!-- / message --><!-- sig -->
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top