LinkBack URL
About LinkBacks
Is there a way to shorten this?
Please Login or Register to view this content.
Is there a way to shorten this?
Please Login or Register to view this content.
Try this:
Does that work for you?Please Login or Register to view this content.
Worked like a charm! Thanks Ron
One last one. I tried your brackets thing and it didn't work?
Please Login or Register to view this content.
When mentioning that a formula "didn't work", it's really helpful if you post that formula. It increases the chances that we'll spot an error.
Absent that...try this:
=SUMPRODUCT(($D31:$D131={"PR","SD","DD","CD","BN"})*($E31:$E131="N")*($F31:$F131))
Does that work?
Hey Ron,
My apologies I will post the formula in the future.
I tried your formula you provided and I got #VALUE! returned:
The formula I was referring to when trying to shorten the first time was also returning a #VALUE!:Please Login or Register to view this content.
Thanks,Please Login or Register to view this content.
Lorne
That would happen if F31:F131 contains text values. Erasing them should help.
If you need the text cells in that range, the solution becomes a bit more complicated.
Let us know what you find.
Well they are not text, they are merely equations that come up empty because our workbook is not populated yet. It will be an ongoing list that continuously populates, but until then there are blank cells...is it possible to ignore that value rule and calculate empty cells?
FYI, rather than using this formula:
I used this and made it not equal to CA rather than typing out all the other codes.Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks