nested countif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a two sheet workbook, the first page being where all data is kept the second being the totals needed. I have a countif function tracking the date of a request made, and it is working great. The problem is that there is now five people taking the requests and I need to get the sum of the requests that each indivdual takes. I am not the greatest at formulas and need assistance with this
 
Ronda said:
----- Frank Kabel wrote: -----

Hi Ronda

as COUNTIF only allows one condition you have to use SUMPRODUCT.
e.g. =SUMPRODUCT(('Sheet1'!A1:A999=your
date)*('Sheet1'!B1:B999="request person))

assuming that column A stores the dates and column B the request
person

HTH
Frank


I tryed this formula but it brings back a zero total and I know that
it should be bringing back two hits any more ideas
=SUMPRODUCT((Summary!F2:F5000=A2)*(Summary!I2:I5000="B1"))
Click to expand...


Hi Ronda,

i think you store your request person in cell B1. If this is correct
just Change "B1" to B1.Currently it searches for a person named B1

This should help. .If not you can email me your Sheet and I'll have a
look at it

Frank
 
Back
Top