irritant (26-03-19)
Google is not on my side today (or I haven't had enough coffee).
I have a table in Excel with the following:
Column D (Initials of users attributed to a payment)
Column C (Current balance)
Column F (Current invoice)
Column L (List of users alphabetically)
Column N (Payment type 1)
Column O (Payment type 2)
So basically, in column O, I need to count the values which meet the criteria:
C = F (in the same row) AND D = L (so I can count the payments on a per-user basis)
I also need to work out the same as above, but in column N where F>C/2.
=COUNTIF($D$2:$D$28,L2) works perfectly, as does =COUNTIF($C$2:$C$28,$F$2:$F$28). I just can't put it together.
Help!
irritant (26-03-19)
Look Here -> |
So you want something like a COUNTIF($D$2:$D$28,L2) AND COUNTIF($C$2:$C$28,$F$2:$F$28) when both are true? You may need VBA using If statetment A=true and statement B=true Then count else go to the next statement.
I'm out of my mind, but feel free to leave a message...
irritant (26-03-19)
Yes. That's exactly what I need.
Ideally, I'd like it automatically done as opposed to having to run a script, but I'm not opposed to it. I guess I could always put it in the script that populates the spreadsheet from the database.
irritant (26-03-19)
Possibly you could get away with IF(formula A, if (formula B, count increment,0),0)
I'm out of my mind, but feel free to leave a message...
irritant (28-03-19)
Bookmarks