Sumifs for specific trade

[Raweya]

Hello, can someone please help me out with a formula that does sumif if I have specific trade and then divide it by the total number of that specific trade?

Let's assume that I have divisions (Yellow, Blue, White, .....) and I want to get the % yellow ones during specific period of the dates and then divide it by the sum of the total number of the yellows

 

[Akira181]

hard to write the formula without knowing what cells the data is in and how it's structured. The below might work

=sumifs(B1:B10, A1:A10, "yellow") / countifs(A1:A10, "yellow")

I assumed Column B has the data to be summed, column A has the division.

 

[Raweya]

thanks for the reply, but can you confirm please,

does the division should be at the right side of the data?

 

[Raweya]

and I want to add a range of dates, the same idea of the below formula, but including the one you mentioned

=COUNTIFS('Steel- SD'!$X$19:$X$30000,">="&'Steel-SD'!E1,'Steel- SD'!$X$19:$X$30000,"<"&'Steel-SD'!F1)

 

[Raweya]

Sorry for writing that question in another post.

so can someone help me please in this:

=SUMIFS('Steel- SD'!$BY$19:$BY$65536,'Steel- SD'!$X$19:$X$991,">="&'Steel-SD'!C1, 'Steel- SD'!$X$19:$X$991,"<"&'Steel-SD'!D1,'Steel- SD'!$A$19:$A$65536, "SD") / COUNTIFS('Steel- SD'!$A$19:$A$65536, "SD")