tinderbox22
Board Regular
- Joined
- Mar 9, 2010
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
Hello,
I'm attempting to do a multi-criteria sum lookup using SUMPRODUCT. I have three conditions and a data set. Within the data set, there are cells that contain text, thus causing a #VALUE error in my SUMPRODUCT formula. The formula works great if I remove the text. Is there a way to make the formula ignore text? I've tried a few things (using --, using ISNUMBER, using both), but none have worked yet, and I'm likely just not doing it correctly.
Formula looks like this:
=SUMPRODUCT(($D$6:$BC$6="January")*($B$19:$B$30="Atlanta")*($C$19:$C$30="TV")*($D$19:$BC$30))
Any help would be appreciated! The -- option still gave me a #VALUE error even when I changed the "*" multiplier to a ","
Thank you!
I'm attempting to do a multi-criteria sum lookup using SUMPRODUCT. I have three conditions and a data set. Within the data set, there are cells that contain text, thus causing a #VALUE error in my SUMPRODUCT formula. The formula works great if I remove the text. Is there a way to make the formula ignore text? I've tried a few things (using --, using ISNUMBER, using both), but none have worked yet, and I'm likely just not doing it correctly.
Formula looks like this:
=SUMPRODUCT(($D$6:$BC$6="January")*($B$19:$B$30="Atlanta")*($C$19:$C$30="TV")*($D$19:$BC$30))
Any help would be appreciated! The -- option still gave me a #VALUE error even when I changed the "*" multiplier to a ","
Thank you!