• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

SUMPRODUCT Formula

Hi,

I have a SumProduct formula which i need tweaking

I need the below (in column C) to say = or greater than 6 and equal to or less than 15

=SUMPRODUCT(--($C$3:$C$1000=">=6"),--($M$3:$M$1000="Corporate Actions"))

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
This is what you are looking for -

=SUMPRODUCT(--($C$3:$C$1000>=6)*($C$3:$C$1000<15),--($M$3:$M$1000="Corporate Actions"))

cheers,
Ardhendu
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Sorry, missed the equal to 15 part... here's the corrected code...

=SUMPRODUCT(--($C$3:$C$1000>=6)*($C$3:$C$1000<=15),--($M$3:$M$1000="Corporate Actions"))

thanks,
Ardhendu
0
 
Seamus2626Author Commented:
Thanks pari123!

Seamus
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now