In an earlier post I discussed about using CONCATENATE and COUNTIF to sum with two conditions. This can be done using the new COUNTIFS command.
Lets look at the following example:
I need to know the number of times machine 9 was used on 4th Jan 2011.
Use formula,
=COUNTIFS(F:F,DATE(2011,1,4),G:G,9)
DONE.
Lets look at the following example:
I need to know the number of times machine 9 was used on 4th Jan 2011.
Use formula,
=COUNTIFS(F:F,DATE(2011,1,4),G:G,9)
You can use up to 127 criteria
DONE.
ExpiresDefault access plus 1 year
Sure! Here's a short 3–4 line blog comment using your keyword naps2 scanner and referencing COUNTIFS: "Thanks for the helpful guide! I was trying to filter scanned data from my naps2 scanner using Excel, and COUNTIFS really came in handy. It made tracking multiple conditions so much easier. Great tip for anyone organizing scanned files!" Would you like variations of this comment?
ReplyDelete