Re: Sum-if-product
- From: Steve <steve_andruszka@xxxxxxxxx>
- Date: Tue, 09 Oct 2007 14:35:21 -0700
Thats it. SOme of the data in the array were errors. Thank you!!!!
On Oct 9, 3:20 pm, "Peo Sjoblom" <terr...@xxxxxxxx> wrote:
The formula itself doesn't return #N/A as written, you might have a N/A
error in any of the ranges
For instance if your results in any of the columns are derived from either
lookups or match then that formula might result in N/A which will make the
sumproduct formula returning it as well
Use F5, click special and look for formula errors
--
Regards,
Peo Sjoblom
" <steve_andrus...@xxxxxxxxx> wrote in message
news:1191963953.552991.210680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi. Does anyone see anything wrong with this formula? It returns an
#N/A and I have no idea why?! Thanks!
=SUMPRODUCT(--(MPD!$B$2:$B$18000=I1),MPD!CE2:CE18000,MPD!$CD$2:$CD
$18000)- Hide quoted text -
- Show quoted text -
.
- References:
- Sum-if-product
- From: Steve
- Re: Sum-if-product
- From: Peo Sjoblom
- Sum-if-product
- Prev by Date: Re: Time formulas
- Next by Date: Re: How to: Find first empty cell in column
- Previous by thread: Re: Sum-if-product
- Next by thread: Re: Time formulas
- Index(es):
Relevant Pages
|
