Hello how could exception handling relevant cells winch not number, cause VALUES error exception in the attached spreadsheet
Hello how could exception handling relevant cells winch not number, cause VALUES error exception in the attached spreadsheet
How aboutFormula:Please Login or Register to view this content.
You are trying to coerce the values in column A to numbers using the double-minus, but this will cause errors if the cell is blank. However, they are already numbers, so you don't need to do that. I prefer to arrange the conditions first, and the numbers to be added after, so try it this way:
=SUMPRODUCT(--(B10:B12=B12),A10:A12)
Hope this helps.
Pete
Thank you it works
Last edited by pozso123; 01-13-2023 at 11:14 AM.
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
C12=sumproduct((n(+a10:a12))*(b10:b12=b12))
Pete's formula works for me. Did you copy it or type it?
Glad to help & thanks for the feedback.
So why that Sumproduct show 0 result if i try use isnumber or iserror function case of one condition, but iserror works only with "or" conditional additional tag.
With 2019,Formula:Please Login or Register to view this content.
So with sum i can filter only 1 conditional but i can filter more with sumproduct and sumifs?
No.So with sum i can filter only 1 conditional but i can filter more with sumproduct and sumifs?Formula:Please Login or Register to view this content.
I don't want to be mean-hearted about excel and I'm really just asking for efficiency, is there any way that makes it faster to perform a function? Because I noticed a slowdown in the PC while evaluating the functions
Maybe reduce the range:Formula:Please Login or Register to view this content.
You just need SUMIF if column E is valid numbers.
=SUM(SUMIF(D:D,{"To CIB*","To AXI*"},E:E))
Notice the * in the texts
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks