# Arrayformula? **URL:** \ **Category:** Ask for Help\ **Created:** [October 6, 2019, 3:17pm UTC](https://community.glideapps.com/t/arrayformula/941 "2019-10-06T15:17:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 3:17pm UTC](https://community.glideapps.com/t/arrayformula/941/1 "2019-10-06T15:17:35Z")
Good Morning could someone help me on an arrayformula to get the amount of product and its value and give the total to pay ![array](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/97c724ba74b3cb7f6090c9bdcf2f5bbecef9d8d4.png) ---
**Author:** ![Carlos](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos/32/456_2.png) [@Carlos](https://community.glideapps.com/u/Carlos)\ **Post date:** [October 6, 2019, 4:10pm UTC](https://community.glideapps.com/t/arrayformula/941/2 "2019-10-06T16:10:30Z")
Here it is: > =ARRAYFORMULA(C3&" “&B3 &” - "&TEXT((C3\*D3),“R$#,##0.00”)) Assuming the values on column D are for a single unit. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 6, 2019, 5:22pm UTC](https://community.glideapps.com/t/arrayformula/941/3 "2019-10-06T17:22:06Z")
I would have written it this way. Then format the Total column to currency. Note that depending on your spreadsheet settings you would use one or the other formulas. ```auto =ARRAYFORMULA(IF(ISBLANK(C2:D),,C2:C*D2:D)) =ARRAYFORMULA(IF(ISBLANK(C2:D);;C2:C*D2:D)) ``` ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 8:31pm UTC](https://community.glideapps.com/t/arrayformula/941/4 "2019-10-06T20:31:03Z")
> [@George\_B](#): > > =ARRAYFORMULA(IF(ISBLANK(C2:D),C2:C\*D2:D)) PODERIA ME AJUDAR COM ESSE ERRO ![ERRO](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/e8022a2a84b76ad6bbf22e645f8ca7e340218964.png) ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [October 6, 2019, 8:35pm UTC](https://community.glideapps.com/t/arrayformula/941/5 "2019-10-06T20:35:32Z")
@gelson First, there is no data in Row 2 of your sample, which is why it will not compute. This error also comes up if there is a Circular Dependancy Detected. You’ll need more data in the other columns for the ArrayFormula code to work, otherwise, it would loop forever. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 8:40pm UTC](https://community.glideapps.com/t/arrayformula/941/6 "2019-10-06T20:40:08Z")
so on line 2 and where the arrayformula goes to prevent me from deleting this line it is just to contain the formula where it would be inserted in the others when it was filled in one sale ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 8:41pm UTC](https://community.glideapps.com/t/arrayformula/941/7 "2019-10-06T20:41:51Z")
Is it because ISBLANK is looking at 2 columns? Try changing ISBLANK(C2:D) to ISBLANK(C2:C). Just guessing here. Or maybe change , to ; ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 8:48pm UTC](https://community.glideapps.com/t/arrayformula/941/8 "2019-10-06T20:48:12Z")
> [@gelson](#): > > =ARRAYFORMULA(IF(ISBLANK(C2:D),C2:C\*D2:D)) sorry I don’t understand much of formulas what I wanted and each sale I made to the arrayformula was to calculate the quantity times the value of the product and inform the tatal of each sale so that I can know the value that each customer is owing ![ERRO](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/73c3ed4ed9b876dc8f0ad6ac6f860d3bc7464e61.png) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 6, 2019, 8:56pm UTC](https://community.glideapps.com/t/arrayformula/941/9 "2019-10-06T20:56:09Z")
The others are correct about row 2. There is a technique to use a row 2 to put formulas in but I don’t do it that way. So for the formula I wrote you should put it in row 3 and change the 2’s to 3’s. Make sure there is no data in the cells below that row in that column. And if you get an error replace the commas with semicolons. What do you have in Row 2? Are they all blank cells?? ```auto =ARRAYFORMULA(IF(ISBLANK(C3:D),,C3:C*D3:D)) -or- (depending on your country and spreadsheet settings) =ARRAYFORMULA(IF(ISBLANK(C3:D);;C3:C*D3:D)) ``` You really need to go online and find some basic Google Sheets tutorials. You are going to run across this kind of thing all the time and need to learn some of the basics. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 9:19pm UTC](https://community.glideapps.com/t/arrayformula/941/10 "2019-10-06T21:19:45Z")
I really thing it’s the use of the the range of columns. Change to only check if one column is blank. I tried it out with the range and it appears to be filling 2 columns instead of 1. The error could be because the next column over has data in it. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 9:24pm UTC](https://community.glideapps.com/t/arrayformula/941/11 "2019-10-06T21:24:32Z")
could build an example for me to have an idea can use the example of my prints ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 9:39pm UTC](https://community.glideapps.com/t/arrayformula/941/12 "2019-10-06T21:39:39Z")
What country do you live in. I want to change my spreadsheet locale to match yours. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 9:40pm UTC](https://community.glideapps.com/t/arrayformula/941/13 "2019-10-06T21:40:58Z")
Also, have you tried with a semicolon ( ; ) instead of comma ( , )? ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 9:42pm UTC](https://community.glideapps.com/t/arrayformula/941/14 "2019-10-06T21:42:43Z")
brasil ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 9:50pm UTC](https://community.glideapps.com/t/arrayformula/941/15 "2019-10-06T21:50:08Z")
look like and i have 1. customer 2nd product 3.The quantity the customer wants 4.The value of the unitary product 5.The date the sale was made 6.Now need the total amount that the customer spent ![ERRO](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/ce4e52f29e7ed9e1ac6408b24fe7bbaba4f0adc8.png) ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 9:51pm UTC](https://community.glideapps.com/t/arrayformula/941/16 "2019-10-06T21:51:23Z")
I don’t speak english so I don’t think the translation is going very well ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 9:54pm UTC](https://community.glideapps.com/t/arrayformula/941/17 "2019-10-06T21:54:22Z")
already put the semicolon but it didn’t work ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 10:02pm UTC](https://community.glideapps.com/t/arrayformula/941/18 "2019-10-06T22:02:50Z")
![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/c35ebe9c354e44ed6fe8ea44b7071449a5c4f4c1.jpeg) ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 10:13pm UTC](https://community.glideapps.com/t/arrayformula/941/19 "2019-10-06T22:13:13Z")
Thank you so it worked just a doubt how do I format currency did it and the error in the formula ![ERRO](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/db17818f124ec0ff6c124bf0912883c8bf4da864.png) ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 6, 2019, 10:16pm UTC](https://community.glideapps.com/t/arrayformula/941/20 "2019-10-06T22:16:39Z")
sorry I got it thanks for the help [Next page](https://community.glideapps.com/t/arrayformula/941.md?page=2)