Author Topic: Excel Help and Problems (Read 344367 times)

etech0 · « **Reply #1280 on:** June 25, 2019, 01:45:07 PM »

Quote from: US on June 25, 2019, 01:43:25 PM

Can someone please help me with SUMIF,

If cell A1 has any text, subtract cell A2 from A3,

I tried =SUMIF(K24:K24,"<>",Q24-V24) but keep on getting an error.

You don't need SUMIF for this. Try:

=IF(A1<>"",A3-A2,"")

This will keep the cell blank if A1 is blank. If you want something else you can change the "" at the end.

skyguy918 · « **Reply #1281 on:** June 25, 2019, 03:10:43 PM »

Quote from: etech0 on June 25, 2019, 01:45:07 PM

You don't need SUMIF for this. Try:

=IF(A1<>"",A3-A2,"")

This will keep the cell blank if A1 is blank. If you want something else you can change the "" at the end.

Or use IFERROR(A3-A2,""). Saves 2 characters

.

etech0 · « **Reply #1282 on:** June 25, 2019, 05:22:58 PM »

Quote from: skyguy918 on June 25, 2019, 03:10:43 PM

Or use IFERROR(A3-A2,""). Saves 2 characters .

US · « **Reply #1283 on:** June 25, 2019, 07:53:54 PM »

Quote from: skyguy918 on June 25, 2019, 03:10:43 PM

Or use IFERROR(A3-A2,""). Saves 2 characters .

Quote from: etech0 on June 25, 2019, 01:45:07 PM

You don't need SUMIF for this. Try:

=IF(A1<>"",A3-A2,"")

This will keep the cell blank if A1 is blank. If you want something else you can change the "" at the end.

Thanks!

Centurion · « **Reply #1284 on:** July 04, 2019, 08:37:18 AM »

I have a list of caller id numbers that called in to a store last 90 days.
I also have a list of the best customers.

how do i find who is on the big list from the customers?
thank you

Yisroel Tech · « **Reply #1285 on:** July 04, 2019, 08:40:42 AM »

Quote from: Centurion on July 04, 2019, 08:37:18 AM

I have a list of caller id numbers that called in to a store last 90 days.
I also have a list of the best customers.

how do i find who is on the big list from the customers?
thank you

From the question it sounds (correct me if I'm wrong) that you don't know very well Excel formulas, and you'd probably wanna see an example formula directly for your situation, but without a sample file from you (for us to see how the layout of the data is) that's not really possible.

(You'd do a VLOOKUP probably.)

Centurion · « **Reply #1286 on:** July 04, 2019, 08:46:55 AM »

Quote from: Yisroel Tech on July 04, 2019, 08:40:42 AM

From the question it sounds (correct me if I'm wrong) that you don't know very well Excel formulas, and you'd probably wanna see an example formula directly for your situation, but without a sample file from you (for us to see how the layout of the data is) that's not really possible.

(You'd do a VLOOKUP probably.)

i tried exact,match,vlookup= i must be doing it wrong example below thanx!

(i did duplicate values and it is finding internal ones and i don't need the ones that called once.)

7180340878   callerid
7180451626   callerid
7180562373   callerid
7180673121   callerid
7180783868   callerid
7180894616   callerid
7181005363   callerid
7181116111   callerid
7181226858   callerid
7181228407   callerid
7181240024   callerid
7181251641   callerid
7181263258   callerid
7181274874   callerid
7181286491   callerid
7181298108   callerid
7181309725   callerid
7181321342   callerid
7181332959   callerid
7181337606   callerid
7181344576   callerid
7181356192   callerid
7181367809   callerid
7181379426   callerid
7181391043   callerid
7181402660   callerid
7181414277   callerid
7181425894   callerid
7181437511   callerid
7181448353   callerid
7181449127   callerid
7181460744   callerid
7181472361   callerid
7181483978   callerid
7181495595   callerid
7181507212   callerid
7181518829   callerid
7181530446   callerid
7181542062   callerid
7181553679   callerid
7181559101   callerid
7181565296   callerid
7181576913   callerid
7181588530   callerid
7181600147   callerid
7181611764   callerid
7181623381   callerid
7181634997   callerid
7181646614   callerid
7181658231   callerid
7181669848   callerid
7181669848   callerid
7181681465   callerid
7181693082   callerid
7181704699   callerid
7181716315   callerid
7181727932   callerid
7181739549   callerid
7181751166   callerid
7181762783   callerid
7181774400   callerid
7181780596   callerid
7181786017   callerid
7181797634   callerid
7181809250   callerid
7181820867   callerid
7181832484   callerid
7181844101   callerid
7181855718   callerid
7181867335   callerid
7181878952   callerid
7181890569   callerid
7181891343   callerid
7181902185   callerid
7181913802   callerid
7181925419   callerid
7181937036   callerid
7181948653   callerid
7181960270   callerid
7181971887   callerid
7181983504   callerid
7181995120   callerid
7182002091   callerid
7182006737   callerid
7182018354   callerid
7182029971   callerid
7182041588   callerid
7182053205   callerid
7182064822   callerid
7182076438   callerid
7182088055   callerid
7182099672   callerid
7182111289   callerid
7182112838   callerid
7182122906   callerid
7182134523   callerid
7182146140   callerid
7182157757   callerid
7182169373   callerid
7182180990   callerid
7182192607   callerid
7182204224   callerid
7182215841   callerid
7182222222   callerid
7182222222   callerid
7182222222   callerid
7182222222   callerid
7182222222   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223131   callerid
7182223586   callerid
7182227458   callerid
7182239075   callerid
7182250692   callerid
7182262308   callerid
7182273925   callerid
7182285542   callerid
7182297159   callerid
7182308776   callerid
7182320393   callerid
7182332010   callerid
7182343626   callerid
7182355243   callerid
7182366860   callerid
7182378477   callerid
7182390094   callerid
7182401711   callerid
7182413328   callerid
7182424945   callerid
7183333333   callerid
7183333333   callerid
7183333333   callerid
7183333333   callerid
7183333333   callerid




7182222222   customers
7183333333   customers
7182223131   customers

Centurion · « **Reply #1287 on:** July 04, 2019, 08:58:24 AM »

=vlookup(A147:A149, A1:A142)

Yisroel Tech · « **Reply #1288 on:** July 04, 2019, 09:17:11 AM »

In C147 you'd want =NOT(ISERROR(MATCH(A147,$A$1:$A$142,0))) to give a True or False if a customer called, and if you want to know how many times they did - if they did - you can also do (in D147) =COUNTIF($A$1:$A$142,A147)

Good?

aygart · « **Reply #1289 on:** July 04, 2019, 03:19:39 PM »

I am trying to track the quantities of 2 needed products contracted for various locations. Each location purchases separately and contracts for each month on its own. Various amounts are contracted at various times depending on a number of factors and some is left uncontracted until the time of use. I have a sheet which can track each location on its own and would like to be able to view a summary of the totals for all locations at once. Is there a formula or any other way to easily have this information update automatically on the summary sheet and be able to easily add locations and/or months? This would need the ability to be able to copy paste the pattern easily if a formula is used. I am open to changing the location sheet if that will make it easier. Sample attached.

Luvisrael · « **Reply #1290 on:** July 04, 2019, 03:56:17 PM »

Importing data from excel to quickbooks and some cella’s are marked in red error. I understand that I have to change the headings to match the text in Quickbooks to be valid data input? When I try doing this they formula, define name, it’s giving me an error saying the syntax of this name isn’t valid. Can someone help me? TIA

Centurion · « **Reply #1291 on:** July 07, 2019, 03:01:25 PM »

Quote from: Yisroel Tech on July 04, 2019, 09:17:11 AM

In C147 you'd want =NOT(ISERROR(MATCH(A147,$A$1:$A$142,0))) to give a True or False if a customer called, and if you want to know how many times they did - if they did - you can also do (in D147) =COUNTIF($A$1:$A$142,A147)

Good?

Excellent! great Job thank you!

I have a salesforce question- didn't find the thread yet. who can I ping?

yitzf · « **Reply #1292 on:** July 07, 2019, 03:08:20 PM »

Quote from: Luvisrael on July 04, 2019, 03:56:17 PM

Importing data from excel to quickbooks and some cella’s are marked in red error. I understand that I have to change the headings to match the text in Quickbooks to be valid data input? When I try doing this they formula, define name, it’s giving me an error saying the syntax of this name isn’t valid. Can someone help me? TIA

Not sure if this is your issue, but the vendor names and account names need the first be in QuickBooks otherwise you'll get that red error. If the names are already there, you might be pulling the wrong columns for example account name in vendor name or vice versa.

Luvisrael · « **Reply #1293 on:** July 07, 2019, 03:19:08 PM »

Quote from: yitzf on July 07, 2019, 03:08:20 PM

Not sure if this is your issue, but the vendor names and account names need the first be in QuickBooks otherwise you'll get that red error. If the names are already there, you might be pulling the wrong columns for example account name in vendor name or vice versa.

im actually putting in inventory

etech0 · « **Reply #1294 on:** July 07, 2019, 03:38:32 PM »

Quote from: Centurion on July 07, 2019, 03:01:25 PM

I have a salesforce question- didn't find the thread yet. who can I ping?

I can try to help.

yitzf · « **Reply #1295 on:** July 07, 2019, 03:43:17 PM »

Quote from: Luvisrael on July 07, 2019, 03:19:08 PM

im actually putting in inventory

I don't have experience with that. So the error is in Excel? Are you putting an = before the name? That could throw the define name error

churnbabychurn · « **Reply #1296 on:** July 07, 2019, 08:21:28 PM »

Quote from: Centurion on July 07, 2019, 03:01:25 PM

Excellent! great Job thank you!

I have a salesforce question- didn't find the thread yet. who can I ping?

Start a thread.. I have limited experience but you never know

etech0 · « **Reply #1297 on:** July 07, 2019, 08:32:42 PM »

Quote from: churnbabychurn on July 07, 2019, 08:21:28 PM

Start a thread

+1

Centurion · « **Reply #1298 on:** July 07, 2019, 08:53:41 PM »

Quote from: churnbabychurn on July 07, 2019, 08:21:28 PM

Start a thread.. I have limited experience but you never know

https://forums.dansdeals.com/index.php?topic=104992.new#new

Am · « **Reply #1299 on:** August 30, 2019, 12:42:16 AM »

Is there a way to trace Dependent or Precedent Cells in Google Sheets?
It's such a basic and easy to use feature in Excel but I can't seem to figure it out in Sheets.
TIA.

Topic Wiki

Author Topic: Excel Help and Problems (Read 344367 times)