How to perform logic for this! *beginner

ksumali

New Member
Joined
Jun 4, 2020
Messages
32
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Dear all,

I want to figure out how to get this problem to work out. I will post an image.

If anyone has any idea on how to do it let me know!


thanks in advance,


I need to know how to count all the cells containing 20F in there BUT only if they also have 9999 as their voyage.

I currently can count the 20F cells but in the VOYAGE column I have more than just 9999 so it gives a number higher than what I need.

Please send troops,

C.
 

Attachments

  • 20f40f.png
    20f40f.png
    2.2 KB · Views: 4
  • 20f9999.png
    20f9999.png
    5.7 KB · Views: 4

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Can you post a small set of sample data with XL2BB so we can easily copy/paste to test with instead of having to manually type out data that may not accurately match what you have?

Does the method need to work in both Excel 365 and Excel 2019 or would just Excel 365 do?

Does your Excel 365 have the FILTER function? If you click the fx button and choose 'Lookup & Reference' is FILTER in the list?

1599713444963.png
 
Upvote 0
Copy of BOOKINGmemoSNKO.xlsx
ABCDEFGHIJKLMNOPQ
1CURRENT WEEKHEUNG-A
2SNKO IMPORT FIGURES 揚げ
340HQ43#COUNT#COUNT#COUNT#COUNT#COUNT#COUNT
440E5207071207279*2074207620782080
5S. TOTAL48#COUNT#COUNT#COUNT#COUNT#COUNT#COUNT
620F5208220842086208820902092
720E26#COUNT#COUNT#COUNT#COUNT#COUNT#COUNT
8S. TOTAL31209420962098210021022104
9G. TOTAL79
10207020722074207620782080
1120F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT
12AVE. COUNT00000
13TOTAL71208420862088209020922094
1420F20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT
1540HQ000000
1640F209821002102210421062108
1720F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT20F TOT40F TOT
18OLD NEW000000
import figures
Cell Formulas
RangeFormula
C1C1=UPPER("current week")
D5,D8D5=SUM(D3:D4)
D9D9=SUM(D8,D5)
H12,P18,N18,L18,J18,H18,F18,P15,N15,L15,J15,H15,F15,P12,N12,L12,J12H12=COUNTIF(DATA!H10:H991,H9=INDIRECT(H9))
C13C13=AVERAGE(G4,I4,K4,M4,O4,Q4,G6,I6,K6,O6,Q6,M6,G8,I8,K8,M8,O8,Q8)
 
Upvote 0
this is the page where I want to have the data be set to go to
specifically F12 and G12
I want to count the total of cells that contain the text 20F and 40HQ in another sheet.

but found this may be impossible the way I am performing this.

Thanks in advance,

C
 
Upvote 0
@Peter_SSs

I looked for the Filter function and no cigar.

I am very new to functions beyond the easy guys!

C
 
Upvote 0
I looked for the Filter function and no cigar.
OK, thanks. Pity.


I want to count the total of cells .... in another sheet.
So, could we also have a small set of sample data (with XL2BB) from that other sheet (that has some cells that should be counted and some that shouldn't)?


where I want to have the data be set to go to
specifically F12 and G12
I want to count the total of cells that contain the text 20F and 40HQ ...
Do you really mean F12 and G12, not C14 & C15?
If you did mean F12 & G12, where does the 40HQ come from in relation to those cells? I can see 20F is included in cell F11 but 40HQ has me confused.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top