D
Dayle
Good morning,
I need to add a count formula ( to add how many cells show a value ) to a
vlookup formula. I am using a spreadsheet that recaps dollars as well as
units per employee number. I am able to capture the dollar amount with
vlookup; I need to be able to calculate how many units were sold. The
information looks this:
employee #01234 sku 123456 $0.00 $0.00 total $12.99
the vlookup formula I am using is this: =VLOOKUP($B2,'Week
1'!$G$6:$K$1532,4,FALSE)
how do I add a count formula to this to add up units per employee number.
Any help with this will be greatly appreciated.
I need to add a count formula ( to add how many cells show a value ) to a
vlookup formula. I am using a spreadsheet that recaps dollars as well as
units per employee number. I am able to capture the dollar amount with
vlookup; I need to be able to calculate how many units were sold. The
information looks this:
employee #01234 sku 123456 $0.00 $0.00 total $12.99
the vlookup formula I am using is this: =VLOOKUP($B2,'Week
1'!$G$6:$K$1532,4,FALSE)
how do I add a count formula to this to add up units per employee number.
Any help with this will be greatly appreciated.