multiply countifs by value in different column of same row

Hey all,

I'm trying to do a countifs formula that find the last value in a row, and counts it if it meets the criteria, but multiplies that count by a quantity in the same row before counting it up. That's probably a poor job explaining, so I've attached a worksheet with an example.

Currently I'm using =COUNTIFS(E9:Q12,"BO",F9:R12,"") to essentially count the "BO" if it's the last item in the row. If that case is true, I want to multiple that count of "1" by the value in column D of the same row, then sum up those cases for "A" and "T" as well. I'm wondering if a sumproduct needs to be used, but no idea how to use it to make what I'm looking for work. Any help would be greatly appreciated.

Thanks!

A real good shot, but unfortunately cant count on today().

I wish I could use the match formula with today(), but these statuses are not automatically input. They're a manual input by people, who don't necessarily do it first thing in the morning. It may not status until late morning or early afternoon, so I need it to be whatever the farthest right value in each row to be the value it counts.

There are about 300 sections just like this, for different part numbers, all calculated separately, so they may also only have half everything updated, so even just picking any one column won't necessarily work. It needs to just count whatever is the farthest right value in each row. Using index seems like a real good bit though, if there's someway to reference whatever column has the last value in each row (so essentialy moving column reference for each row), then that would work.

Originally Posted by vlady

any possibility of uncomplete entry in a certain column say

oct 10 column

blank so this cell is blank but the remaing contains entry
BO
A
T

Yes, this is quite possible.